34,588
社区成员
发帖
与我相关
我的任务
分享
exec ('select '+@allname+'='+@allname+','+'name from syscolumns where id=(select id from sysobjects where name=''GZ_bendibao_zf_data'')and colid='+@nowcolid)
declare @allname varchar(50),@nowcolid varchar(50)
set @allname='a'
set @nowcolid='1'
exec ('select '+@allname+'='''+@allname+''','+'name from syscolumns
where id=(select id from sysobjects where name=''tb'')
and colid='''+@nowcolid+'''')
DECLARE @sqlstr varchar(800)
@sqlstr ='DECLARE @allname varchar(500);'
@sqlstr =@sqlstr +'DECLARE @nowcolid int;'
@sqlstr =@sqlstr +'set @allname=XXXXX;'
@sqlstr =@sqlstr +'set @nowcolid = 123456;'
@sqlstr=@sqlstr +'select @allname=@allname+name from syscolumns where id=(select id from sysobjects where name=''GZ_bendibao_zf_data'') and colid='
@sqlstr=@sqlstr + '@nowcolid'
exec(@sqlstr)