Stored Procedures

1) Open SQL Management Studio. Enter username and password.

2) In database which you create click on Programmability----> Stored Procedure option as in image.

3) Right click on stored procedure and add new---> in open tab select all and delete.

4)Then in empty tag. Write code as shown in image 2. in place of Alter Procedure write create procedure and stored procedure name. And other line behind that are same.

5) Syntax for Display.

3) Syntax for Update.

6) Syntax for Delete.

7) Syntax for Insert.