帮忙看下这个动态语句 谢谢

[一者仁心]

exec ('select '+@allname+'='+@allname+','+'name from syscolumns where id=(select id from sysobjects where name=''GZ_bendibao_zf_data'')and colid='+@nowcolid)

[arrow_gx]

把定义 @allname，给@allname赋值的语句一起包含到动态语句里面就可以了

[arrow_gx]

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)
 
 

[wzy_love_sly]

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+'''')

a name
a H_Date

[free1879]

'select @allname=@allname' 这是什么？

and 前边加一个空格

[一者仁心]

楼上的
我想要给@allname赋值

[一者仁心]

不好意思 各位 弄了个低级错误 我了解俄