27,582
社区成员




DECLARE @dt DATETIME
DECLARE @tb VARCHAR(50)
DECLARE @sql VARCHAR(2000)
SELECT @dt = '2013-02-01'
SELECT @tb = 'CS_'+datename(YY,@dt)+datename(MM,@dt)
SELECT @sql = 'create table ' + @tb + '(t1 varchar(50))'
IF OBJECT_ID(@sql) IS NULL EXEC(@sql)
DECLARE @i INT,@count INT
SELECT @i = 1,@count = 6
WHILE(@i <= @count)
BEGIN
SELECT @tb = 'CS_'+datename(YY,DATEADD(mm,@i-1,@dt))+datename(MM,DATEADD(mm,@i-1,@dt))
SELECT @sql = 'create table ' + @tb + '(t1 varchar(50))'
IF OBJECT_ID(@sql) IS NULL EXEC(@sql)
SELECT @i = @i + 1
END