TA貢獻(xiàn)1846條經(jīng)驗(yàn) 獲得超7個贊
TA貢獻(xiàn)1842條經(jīng)驗(yàn) 獲得超13個贊
EXEC('SELECT * FROM ' + @tablename)--DECLARE TABLE NAME VARIABLE DYNAMICALLYDECLARE @table_name varchar(max)SET @table_name =
(SELECT 'TEST_'
+ DATENAME(YEAR,GETDATE())
+ UPPER(DATENAME(MONTH,GETDATE())) )--DROP THE TABLE IF IT ALREADY EXISTSIF EXISTS(SELECT name
FROM sysobjects
WHERE name = @table_name AND xtype = 'U')BEGIN
EXEC('drop table ' + @table_name)END--CREATES TABLE FROM DYNAMIC VARIABLE AND INSERTS ROWS FROM ANOTHER TABLEEXEC('SELECT * INTO '
+ @table_name + ' FROM dbo.MASTER WHERE STATUS_CD = ''A''')
TA貢獻(xiàn)1825條經(jīng)驗(yàn) 獲得超6個贊
DECLARE @sqlCommand varchar(1000)SET @sqlCommand = 'SELECT * from yourtable'EXEC (@sqlCommand)
舉報