CREATE PROCEDURE DisplayInfo @employee_id int
AS
DECLARE
@name nchar(30),
@department nchar(30),
@age int,
@salary real
BEGIN
SET @name= (SELECT Name FROM Employees WHERE [Employee ID]=@employee_id)
SET @department= (SELECT Department FROM Employees WHERE [Employee ID]=@employee_id)
SET @age= (SELECT Age FROM Employees WHERE [Employee ID]=@employee_id)
SET @salary= (SELECT Salary FROM Employees WHERE [Employee ID]=@employee_id)
PRINT('Employee Name is:'+ @name)
PRINT('Employee Department is:'+@department)
PRINT('Employee Age is:'+STR(@age))
PRINT('Employee Salay is:'+STR(@salary))
END
GO