62,074
社区成员
发帖
与我相关
我的任务
分享
疯子, 这个临时表不是在动态语句中创建的。作用域还在。。。
不信你可以试试:
create proc wsl
as
select * into # from aaa
select * from #
然后调用该存储过程绝对没错。。。
另楼主,你的存储过程应该没什么问题,应该是你调用错了。。
正确调用:
exec selectDepAndUser @DepID=2,@UserID = 24
--或者:
exec selectDepAndUser 2,24
切勿:
exec selectDepAndUser (@DepID=2,@UserID = 24)
ALTER PROCEDURE dbo.selectDepAndUser
(@DepID int)
AS
select DepID,DepName,DepNumClass into #DepB_temp from DepB where DepNumClass=@DepID
SELECT UserB.UserID, UserB.UserInfoName, UserB.UserName, UserB.DepID,#DepB_temp.DepID,
#DepB_temp.DepName,#DepB_temp.DepNumClass
FROM #DepB_temp INNER JOIN
UserB ON #DepB_temp.DepID = UserB.DepID
return
select UserB.UserID, UserB.UserInfoName,UserB.UserName,UserB.DepID,
DepB.DepID, DepB.DepName,DepB.DepNumClass
from DepB inner join userb on DepB.DepID=UserB.DepID
where DepB.DepNumClass=@DepID