用动态SQL 实现带参数的 identity函数功能(可以实现给列前加上序号的功能)
declare @a int,@s varchar(100)
set @a = 100
set @s = 'Select top 10 identity(int,'+cast(@a as char(3))+',2) as XH into ##t from sysobjects'
--print @s
exec(@s)
Select * from ##t
declare @a int,@s varchar(100)
set @a = 100
set @s = 'Select top 10 identity(int,'+cast(@a as char(3))+',2) as XH into ##t from sysobjects'
--print @s
exec(@s)
Select * from ##t