SELECT变量多值赋值 举例说下
比如表 test 字段 sname,[email protected]
------解决方案--------------------
- SQL code
create table #test(name varchar(10))goinsert #testselect 'tracy' union allselect 'lucy' union allselect 'kobe'godeclare @str varchar(50)set @str=''select @[email protected]+','+name from #testselect RIGHT(@str,LEN(@str)-1) as name/*nametracy,lucy,kobe*/