Create Stored Procedure Using MS SQL Mgt Studio

Stored procedure Introduction

When we consider about the SQL Stored Procedure basically it is a one of the powerful characteristic which SQL Server exits. Basically Stored Procedure has following characteristic.

• Pre- Defined
• Reusable routine that is stored in a DB
• Efficient
• Dynamically building queries
• Parameter support

Create Stored Procedure Using Microsoft SQL Server Management Studio.
As a first step it is very important to select the database which you want to create Stored Procedure. And next select the Programmability in there select Stored Procedure. Write click on Stored Procedure and by giving suitable name for Stored Procedure you can create Stored Procedure. Figure 1 show how to create Stored Procedure.



















Figure 1: How to create Stored Procedures for particular Database.

When you create stored procedure you can find file as Figure 2. According to your purpose you can create suitable stored procedure by adding necessary code on that Stored Procedure file and you can save them. After that easily can use to our application.













Figure 2 show that Stored Procedure File.

Your Comments are highly appreciated; it will be improving my knowledge also.