DECLARE @MyTableName nvarchar(20);DECLARE @DynamicSQL nvarchar(1000);SET @MyTableName = "FooTable";SET @DynamicSQL = N'SELECt * INTO ' + @MyTableName + ' FROM BarTable';EXEC(@DynamicSQL);
DECLARE @MyTableName nvarchar(20);DECLARE @DynamicSQL nvarchar(1000);SET @MyTableName = "FooTable";SET @DynamicSQL = N'SELECt * INTO ' + @MyTableName + ' FROM BarTable';EXEC(@DynamicSQL);
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
