批量建表

declare @i int 

declare @tablename varchar(200)

set @i=41

while @i<61

begin 

set @tablename='[newdocuement'+cast(@i AS varchar(10)) +']';

EXEC('CREATE TABLE dbo.'+@tablename+'(

[Articleid] [bigint] IDENTITY(1,1) NOT NULL,

[Filesize] [Float] NULL,

[Uploadfilename] [Varchar](200) NULL,

[Physiclefilename] [Varchar](200) NULL,

[Downloadtime] [Int] NULL,

[Offvalue] [Smallint] NULL,

[Filedomainname] [Varchar](50) NULL,

[Htmldomainname] [Varchar](50) NULL,

[Physiclehtmlpath] [Varchar](200) NULL,

[Pagenum] [int] NULL,

[Httppath] [Varchar](200) NULL,

[Filetype] [int] NULL,

[Permitdownload] [int] NULL,

[Extractstatus] [int] NULL,

[Convertstatus] [int] NULL,

[SheetName] [Varchar](500) NULL,

) ON [PRIMARY]')

EXEC('CREATE CLUSTERED INDEX [idx_Articleid] ON [dbo].'+@tablename+'([Articleid])');

set @i=@i+1 

end