declare @SUBNo int
select @SUBNo=4
select IDENTITY(int,@SUBNo,1) ID_Num ,a.* INTO #TMP from table a
提示 '第 6 行: '@SUBNo' 附近有语法错误。'
IDENTITY无法接受参数吗?
如何才能实现通过参数替增的功能!环境:SQL2000
select @SUBNo=4
select IDENTITY(int,@SUBNo,1) ID_Num ,a.* INTO #TMP from table a
提示 '第 6 行: '@SUBNo' 附近有语法错误。'
IDENTITY无法接受参数吗?
如何才能实现通过参数替增的功能!环境:SQL2000
select @SUBNo=4
exec('select IDENTITY(int,'+@SUBNo+',1) ID_Num ,a.* INTO #TMP from table a')
select @SUBNo=4
exec('select IDENTITY(int,'+@SUBNo+',1) ID_Num ,a.* INTO #TMP from table a select *from #TMP')
declare @SUBNo int
select @SUBNo=4
exec('select IDENTITY(int,'+@SUBNo+',1) ID_Num ,a.* INTO ##TMP from table a select *from #TMP')
select *from ##TMP
declare @SUBNo int
select @SUBNo=4
exec('select IDENTITY(int,'+@SUBNo+',1) ID_Num ,a.* INTO ##TMP from table a ')
select *from ##TMP
declare @SUBNo int
select @SUBNo=4
exec('select IDENTITY(int,'+@SUBNo+',1) ID_Num ,a.* INTO ##TMP from table a ')
select *from ##TMP楼上正解。
select @SUBNo=4
exec('select IDENTITY(int,'+@SUBNo+',1) ID_Num ,a.* INTO #TMP from sysobjects a
select * from #TMP')
create table #T(ID int)
declare @SUBNo int
select @SUBNo=4
exec('select IDENTITY(int,'+@SUBNo+',1) ID_Num INTO #TMP from sysobjects a
insert #T select * from #TMP')
select * from #T
用動態生成臨時表或全局臨時表
或
先建