BEGIN
declare a int default 1;
set a=x;
select userid into @b from userinfo where deptid=a;
select userid,salary from salaryinfo where userid=@b;
END
存储过程如上,第一条SQL语句查询出的结果不止一条 应该怎么改?求大神指教!
额 我就是把一条拆两天看看效果的...
追答BEGIN
declare a int default 1;
set a=x;
declare @b table(userid int);
insert into @b select userid from userinfo where deptid=a;
select userid ,salary from eWL_Role where userid in (select * from @b);
END
这个怎么样,满意不?
额 提示说
declare @b table(userid int);
insert into @b select userid from userinfo where deptid=a;附近有语法错误...
select userid ,salary from salaryinfo where userid in (select * from @b);
本回答被提问者采纳额 存储过程要用java吗?
追答我以为你在制作jsp呢!