REATE PROCEDURE CreatePerspective ASdeclare cursorp cursor for select TableName from OverallPerspectivedeclare @j varchar(1000)
open cursorpfetch cursorp into @j
while @@fetch_status=0
begin
if not exists (exec('select * from dbo.sysobjects where id = object_id(N''[' + @j + ']'') and OBJECTPROPERTY(id, N'IsUserTable') = 1'))
begin
exec('select * into '+@j+' from Perspective')
end
fetch cursorp into @j
end
close cursorp
deallocate cursorp
GO
open cursorpfetch cursorp into @j
while @@fetch_status=0
begin
if not exists (exec('select * from dbo.sysobjects where id = object_id(N''[' + @j + ']'') and OBJECTPROPERTY(id, N'IsUserTable') = 1'))
begin
exec('select * into '+@j+' from Perspective')
end
fetch cursorp into @j
end
close cursorp
deallocate cursorp
GO
open cursorpfetch cursorp into @j
while @@fetch_status=0
begin
if object_id(@j) is null
exec('select * into '+@j+' from Perspective')
fetch cursorp into @j
end
close cursorp
deallocate cursorp
GO
open cursorpfetch cursorp into @j
while @@fetch_status=0
begin
if not exists (select * from dbo.sysobjects where id = object_id(N'[' + @j + ']') and OBJECTPROPERTY(id, N'IsUserTable') = 1) --判断该表是否存在
begin
exec('select * into '+@j+' from Perspective')
end
fetch cursorp into @j
end
close cursorp
deallocate cursorp
GO