A表是需要备份的表,如何以select into语句备份表A且表名要含有当前日期。下列语句有问题:
SELECT * INTO 'A_bak'+CONVERT(VARCHAR(30),GETDATE(),12) as tabname FROM A;正确的应该怎么写呢
SELECT * INTO 'A_bak'+CONVERT(VARCHAR(30),GETDATE(),12) as tabname FROM A;正确的应该怎么写呢
exec ('SELECT * INTO A_bak_'+CONVERT(VARCHAR(30),GETDATE(),12)+' FROM A')
set @sN ='a_Bak_'+CONVERT(VARCHAR(30),GETDATE(),12)
exec('SELECT * INTO '+@sn+' from a')
exec('SELECT * INTO A_bak'+CONVERT(VARCHAR(30),GETDATE(),12)+' as tabname FROM A')