从纯语法角度来说应该是这样的:
select BjdId,
(select count(*) from UserTable where BjuBjdId=BjdId) into PlayNum,
dbo.F_UserFunction(BjdId) into IsOpen
from UserTable where BjdRoomId= " || roomid;
select BjdId,
(select count(*) from UserTable where BjuBjdId=BjdId) into PlayNum,
dbo.F_UserFunction(BjdId) into IsOpen
from UserTable where BjdRoomId= " || roomid;
给了权限再测一下