هذا البروسيجر كامل يطلعلي خطاء عند كلمة where
CREATE procedure [Select_All]
@Employee_ID_1 int(4)
AS SELECT dbo.Employee.Employee_ID, dbo.Employee.Employee_Name_E, dbo.Employee.Employee_Name_A, dbo.Employee.Department, dbo.Salary.ID_Salary,
dbo.Salary.Basic_Salary, dbo.Salary.Transport, dbo.Salary.Accomadotion, dbo.Salary.Helth, dbo.Salary.Life_EX, dbo.Salary.Another,
dbo.Salary.Travel, dbo.Salary.Discount, dbo.Salary.Barrow, dbo.Salary.Extra, dbo.Salary.Total, dbo.Extra.Disc_Extra, dbo.Barrow.Disc_Barrow,
dbo.Discount.Disc_Discount
FROM dbo.Employee INNER JOIN dbo.Barrow ON dbo.Employee.Employee_ID = dbo.Barrow.ID_Employee INNER JOIN dbo.Discount ON dbo.Employee.Employee_ID = dbo.Discount.ID_Employee INNER JOIN dbo.Salary ON dbo.Employee.Employee_ID = dbo.Salary.ID_Employee INNER JOIN WHERE Employee .Employee_ID = @Employee_ID_1
GO