declare @code varchar(20)
select @code = '21'
declare @sqlcod varchar(1024)
set @sqlcod=' select IDENTITY(int, 1,1) AS ID_Num, * into ##temp from custrights where tt_code='''+@code+''''
exec (@sqlcod)
select * from ##temp
select @code = '21'
declare @sqlcod varchar(1024)
set @sqlcod=' select IDENTITY(int, 1,1) AS ID_Num, * into ##temp from custrights where tt_code='''+@code+''''
exec (@sqlcod)
select * from ##temp
解决方案 »
- sqlServer6.5 与 SqlServer2000的区别
- 请大家帮我看下
- 如果用脚本实现将一个主键上的聚集索引改成非聚集索引.当天结贴,在线关注 急用,谢谢各位帮助
- 请问,能不能写一句这样的sql语句。。。??
- 求此sql语句的意思!
- SQL6.5升级到2000后出现的疑难问题
- 求查询语句,急用!
- 真是奇怪了,自动增量ID在本机下运行添加正常,但是上传到万网的SQL Server服务器中就出现错误提示“无法将 NULL 值插入列 'ID'”?
- 急!怎么更新?
- 主表1亿条,子表10万条,关联查询,在不分表的情况下,速度能提升吗?
- 如何得到数据库已用空间,见内
- 谢谢大家进来看看关于修改日志文件大小的问题
select @code = '21'
declare @sqlcod varchar(1024)create table #tem1(id_num int identity(1,1),其他列....)set @sqlcod='insert #tem1 (除了id_num的其他列) select * from custrights where tt_code='''+@code+''''
exec (@sqlcod)select * from #tem1
select @code = '21'
declare @sqlcod nvarchar(1024)
set @sqlcod=N' select IDENTITY(int, 1,1) AS ID_Num, * into #temp from custrights where tt_code='+@code + ' select * from #temp '
execute sp_executesql @sqlcod,N'@code char(20)',@code
select @code = '21'
declare @sqlcod nvarchar(1024)
select identity(int,1,1) as id_num,* into #temp from custrights where 1=2
set @sqlcod=N'insert into (col1,col2....ID_NUM不要放进来) select * into from custrights where tt_code='+@code
execute @sqlcod
select * from #temp
select @code = '21'
declare @sqlcod nvarchar(1024)
select identity(int,1,1) as id_num,* into #temp from custrights where 1=2
set @sqlcod=N'insert into (col1,col2....ID_NUM不要放进来) select * into from custrights where tt_code='+@code
execute @sqlcod
select * from #temp