给定一个操作员ID时加载所有详细信息 [英] Loading all the details when given One operator id

问题描述

你好，



我用内连接写了storedprocedure ..当我执行sp并传递ID时...它显示所有细节而不是显示详细信息我通过身份证的员工





谢谢

Hello,

I wrote storedprocedure with inner join ..when i execute sp and passed ID...its showing all the details rather then showing the details of the employee for whom i passed ID


Thank you

推荐答案

可能是你错过了把过滤器用'WHERE`

试试这个

May be you have missed to put the filter using `WHERE`
Try this

create proc [dbo].[YourSpName]
(
   @EmployeeId int
)
as
begin
   select FirstName,LastName,UserType,Salary,Date
   From Employee Emp
   inner join EmployeeDetails empdetails on Emp.EmployeeID=EmployeeDetails.EmployeeID
   where Emp.EmployeeID=@EmployeeId
end

希望，它有帮助：）

Hope, it helps :)

添加一个WHERE您查询的子句：

Add a WHERE clause to your query:

SELECT FirstName,LastName,UserType,	
Salary,Date	
FROM Employee Emp
INNER JOIN EmployeeDetails empdetails
ON Emp.EmployeeID=EmployeeDetails.EmployeeID
WHERE Emp.EmployeeID=@IDValueIwantToFindAndPassedAsAParameter

SELECT FirstName，LastName，UserType，

薪资，日期

来自员工Emp

INNER JOIN员工详细信息

ON Emp.EmployeeID = EmployeeDetails.EmployeeID

WHERE Emp.EmployeeID ='emp123'

SELECT FirstName,LastName,UserType,
Salary,Date
FROM Employee Emp
INNER JOIN EmployeeDetails empdetails
ON Emp.EmployeeID=EmployeeDetails.EmployeeID
WHERE Emp.EmployeeID='emp123'

这篇关于给定一个操作员ID时加载所有详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！