为两个查询编写一个存储过程 [英] writing a single stored procedure for two queries

问题描述

hai friendz，
我写了两个sp
一个是用于通过EmployeeId选择AdminId

hai friendz,
i written two sp''s

one is for Selecting AdminId by EmployeeId

select AdminId from Employee where EmployeeId=@EmpId

另一个是用于通过AdminId选择公司名称

another one is for Selecting CompanyName by AdminId

select E.CompanyId,C.CompanyName from Employee E,Company C where E.AdminId =@AdminId and E.CompanyId=C.Id 

我想在我传递EmployeeId的地方通过AdminId选择CompanyName.因此我为此写了两个sp.s..

有什么办法可以将这两个sp.s组合起来吗?
我想将这两个写在一个单独的...

请帮帮我

在此先感谢

i want to select CompanyName by AdminId where I am passing EmployeeId..so i written two sp''s for that..

Is there any way to combine these two sp''s..
I want to write these two in a single sp...

Please help me

Thanks in advance

推荐答案

SELECT e.AdminId , s.CompanyName,s.CompanyId
   FROM Employee e
   INNER JOIN Company s
           ON e.AdminId = s.AdminId
  WHERE e.EmployeeId=@EmpId

SELECT e.AdminId，s.CompanyName，s.CompanyId
来自员工e
内联公司s
开启e.AdminId = s.AdminId
如果条件是您的Sp
，则e.EmployeeId=@EmpId和E.AdminId = @ AdminId

SELECT e.AdminId , s.CompanyName,s.CompanyId
FROM Employee e
INNER JOIN Company s
ON e.AdminId = s.AdminId
WHERE e.EmployeeId=@EmpId and E.AdminId =@AdminId

u可以使用

u can use if condition i your Sp

IF condition 
(statement)
Else 'if insert returns an error'
( statement)
end

这篇关于为两个查询编写一个存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！