有没有办法使identity的始量,可以用变量来替代?
declare @beginnum as int
set @beginnum = 88
select identity(int,@beginnum,1) as iden into #t1 from sysobjects
select * from #t1
drop table #t1

上面的是错误的,那么有没有办法使identity的始量,可以用变量来替代?

进一步说,有没有办法,可以使identity的始量和增量,可以用变量来替代?


[解决办法]
那只有用动态SQL实现。

declare @beginnum as int, @sql varchar(1000)

set @beginnum = 88

set @sql = 'select identity(int, ' + cast(@beginnum as varchar(100)) + ',1) as iden into #t1 from sysobjects select * from #t1 drop table #t1 '

print @sql

exec (@sql)