完整的句子如下:(就是复制表的功能)
CREATE PROCEDURE NewTable(@table1 varchar(50),@table2 varchar(50))
AS
begin
declare @sqlstr varchar(500)
declare @keys varhcar(50)
select @keys=column_name from (exec('sp_pkeys '+ @table1))
@sqlstr = ' if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].['+@table2+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)'+
' drop table [dbo].['+@table2+']'+
' GO ' +
' select * into '+@table2+ ' from ' + @table1 +
' GO ' +
' ALTER TABLE ['+@table2+'] ADD ' +
' CONSTRAINT [PK_'+@table2+'] PRIMARY KEY CLUSTERED (['+@keys+']) ON [PRIMARY] ' +
' GO '
print @sqlstr
exec(@sqlstr)
end
CREATE PROCEDURE NewTable(@table1 varchar(50),@table2 varchar(50))
AS
begin
declare @sqlstr varchar(500)
declare @keys varhcar(50)
select @keys=column_name from (exec('sp_pkeys '+ @table1))
@sqlstr = ' if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].['+@table2+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)'+
' drop table [dbo].['+@table2+']'+
' GO ' +
' select * into '+@table2+ ' from ' + @table1 +
' GO ' +
' ALTER TABLE ['+@table2+'] ADD ' +
' CONSTRAINT [PK_'+@table2+'] PRIMARY KEY CLUSTERED (['+@keys+']) ON [PRIMARY] ' +
' GO '
print @sqlstr
exec(@sqlstr)
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货