DECLARE A CURSOR FOR select userid from tbl_user open A declare @userid varchar(100) FETCH NEXT FROM A INTO @userid
WHILE @@FETCH_STATUS = 0 BEGIN exec('if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[File'+@userid+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1) drop table [dbo].[File] ') exec('CREATE TABLE [dbo].[File'+@userid+'] ([ID] [int] IDENTITY (1, 1) NOT NULL , [fileName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [fileType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [fileSize] [float] NULL , [fileContext] [image] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ') FETCH NEXT FROM A INTO @userid ENDCLOSE A DEALLOCATE A
DECLARE A CURSOR FOR select userid from tbl_user open A declare @userid varchar(100) FETCH NEXT FROM A INTO @userid
WHILE @@FETCH_STATUS = 0 BEGIN exec('if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[File'+@userid+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1) exec('drop table [dbo].[File'+ @userid+']') ') exec('CREATE TABLE [dbo].[File'+@userid+'] ([ID] [int] IDENTITY (1, 1) NOT NULL , [fileName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [fileType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [fileSize] [float] NULL , [fileContext] [image] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ') FETCH NEXT FROM A INTO @userid ENDCLOSE A DEALLOCATE A
open A
declare @userid varchar(100)
FETCH NEXT FROM A INTO @userid
WHILE @@FETCH_STATUS = 0 BEGIN
exec('if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[File'+@userid+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)
drop table [dbo].[File]
') exec('CREATE TABLE [dbo].[File'+@userid+'] ([ID] [int] IDENTITY (1, 1) NOT NULL ,
[fileName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fileType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fileSize] [float] NULL ,
[fileContext] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
') FETCH NEXT FROM A INTO @userid
ENDCLOSE A
DEALLOCATE A
open A
declare @userid varchar(100)
FETCH NEXT FROM A INTO @userid
WHILE @@FETCH_STATUS = 0 BEGIN
exec('if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[File'+@userid+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)
exec('drop table [dbo].[File'+ @userid+']') ') exec('CREATE TABLE [dbo].[File'+@userid+'] ([ID] [int] IDENTITY (1, 1) NOT NULL ,
[fileName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fileType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[fileSize] [float] NULL ,
[fileContext] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
') FETCH NEXT FROM A INTO @userid
ENDCLOSE A
DEALLOCATE A
删除表时错了