自动复制表

DECLARE @i INT = 0
DECLARE @Count INT = 6
DECLARE @sql NVARCHAR(MAX)
WHILE (@i < @Count)
BEGIN
    DECLARE @iStr NVARCHAR(10) = CAST(@i AS NVARCHAR(10))
    SET @sql = 'IF OBJECT_ID(N''PushQueue_' + @iStr + ''', N''U'') IS  NULL
begin
SELECT * INTO [PushQueue_' + @iStr + '] FROM dbo.PushQueue WHERE 1=0
alter table  [PushQueue_' + @iStr + '] add CONSTRAINT PK_PushQueue_' + @iStr + ' primary key(ID)
end
'
    PRINT @sql
    SET @i = @i + 1
END