Creating stored procedures

A stored procedure is a group of one or more Transact-SQL statements stored in the database data dictionary and compiled as a single execution plan. We will create stored procedures that we will use to select, insert, update, and delete data from the Employee and Department tables we just created. Here is a list of the stored procedures that we will create for our Payroll database:

• Employee_Select
• Employee_Insert
• Employee_Update
• Employee_Delete
• Department_Select
• Department_Insert
• Department_Update
• Department_Delete

The following code shows the complete scripts for each of the stored procedures for the Employee and Department tables:

Create Procedure Employee_Select
as
Select EmployeeID, FirstName, LastName, Address,Phone, DepartmentDepartmentID, JoiningDate,CreatedDate_DateCreated 
from Employees
Go

Create Procedure Employee_Insert
@FirstName varchar(50), @LastName varchar(50), @Address varchar(200), 
@Phone varchar(20), @DepartmentID int, @JoiningDate datetime, @DateCreated...