Inserting Record in Table using Stored Procedure

In this blog you will learn how to insert record in a table using a simple stored procedure.

This Example show you how to insert an record in table using simple stored procedure using T-SQL.

1. Query for creating Database, you can name the database what you want.
   
   
   
   
2. Now Second Step is to Create Table for inserting Records of Employees.
   
   
   
   
3. Query for Creating Table is given below.
   
   
   
   
4. Now Create an Stored Procedure for inserting Record in Employees Table, Query for creating Stored procedure is given below.
   
   
   
   
5. Now Run the Stored procedure you will get an Message 'Record Successfully Entered".
   
   
   
   
6. Now Check the Table to see that record inserted or not
   
   

So We Finally Enter the Record Using Simple Insert Stored Procedure.