CREATE PROCEDURE SetSerialNum
@TableName varchar(40), @TableCloName varchar(40)
AS
begindeclare @sql varchar(8000)
set @sql ='declare @i int Set @i = 0 Update ' + @TableName + ' Set @i =@i + 1,' + @TableCloName + ' = @i'
print @sqlexec (@sql)
end
GO
@TableName varchar(40), @TableCloName varchar(40)
AS
begindeclare @sql varchar(8000)
set @sql ='declare @i int Set @i = 0 Update ' + @TableName + ' Set @i =@i + 1,' + @TableCloName + ' = @i'
print @sqlexec (@sql)
end
GO
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货