How to write a procedure?

Write a script to create a stored procedure in T-SQL.?

• Write a script to create a stored procedure in T-SQL. The stored procedure should update a row in the Employee table provided below. It should accept an Employee's Name and EmailAddress and PositionID. Using the Name and EmailAddress, the stored procedure should update that employee's position. Employee Name varchar(50) EmailAddress varchar(250) Birthdate datetime Startdate datetime Enddate datetime PositionID int DepartmentID int Department DepartmentID int Name varchar(50) FoundingDate datetime Position PositionID int Name varchar(50) CreationDate datetime

• Answer:

  CREATE PROCEDURE EmployeeUpdate @Name varchar(50), @EmailAddress varchar(250), @PositionID int AS BEGIN UPDATE Employee SET PositionID = @PositionID WHERE [Name] = @Name AND EmailAddress = @EmailAddress END The preceding code does not have any error handling and assumes that Name and EmailAddress will always exist, so be sure and check for that in your program before running the procedure.