求 以下语句在 存储过程中怎么写?
要求输出 all_id,我只会在ASP里写,先谢谢各位了
set rs=execute("select ID from B")
Do While Not Rs.EOF
if rs("ID")<>0 then all_id=all_id&","&rs("ID")
Rs.MoveNext
loop
Rs.close
要求输出 all_id,我只会在ASP里写,先谢谢各位了
set rs=execute("select ID from B")
Do While Not Rs.EOF
if rs("ID")<>0 then all_id=all_id&","&rs("ID")
Rs.MoveNext
loop
Rs.close
from b where id <> 0;select @s;
SELECT @STR=ISNULL(@STR+',','')+LTRIM(ID) FROM B
SELECT @STR?
select all_id + ltrim(id) from b where id <> 0