Use Of Stored Procedure in SQL Server

[technika]

Hello, I am learning SQL server and while learning it, it is quiet complicated to get the stored procedure. It is too much difficult for me to understand. If anyone is having any type of details which will help me to understand this concept then please help me to get that.

[Praetor]

If you want to use the stored procedure then follow the steps below:
1. We first establish the connection to the database.
2. We create an SQL command type stored procedure that will allow us to use the procedure created.
3. We add the parameters needed for executing the stored procedure.
4. Finally, we execute the command and the object's.

[Katty]

To write debug and execute stored procedures in a database SQL Server you must use Query Analyzer (Query Analyzer). To create a new procedure, enter the word in the Query pane and press Ctrl + E to execute its definition. Attention understand that this action is that the procedure to attach the database but does not actually execute the stored procedure itself!

To execute a stored procedure you must run the following statement: EXECUTE :To create a new stored procedure and attach it to the database being you must use the CREATE PROCEDURE. The general syntax of the statement is as follows:
CREATE PROCEDURE:

CREATE PROCEDURE procedure_name AS 
{ 
procedure definition
}

Procedure_name Where is the name of the new stored procedure and the block of statements following the keyword AS is the procedure body.

[kelfro]

Stored procedure is used for the purpose below:

• You can save and reuse your Execution plan in future
• You can provide your query auto-parameterization
• You will able to secure your business rules and policies
• It is simple to modularize your program.
• You can share your logic.
• You can simply access the objects of database.
• By the use of it you can simply save your network bandwidth.
• Stored procedure can automatically executed.
• It will increase your hardware and software working.
• Security is increased.

[Zecho]

If you want to create a stored procedure and if you are making use of the Enterprise Manager of SQL Server 2000 then follow the steps below:

• Select the database on which we work (For example, the database called "VMTPK).
• Go to Stored Procedures.
• In the Action menu, select "New Stored Procedure".
• Done.

[Reegan]

Some of the time there is necessary to use the Stored Procedure which are as below:

• When multiple client applications are written in different languages on different platforms, and use the server as a point of interaction.
• Where safety is a priority.
• Banks, for example, use stored procedures for all operations standards. This leads to a coherent and secure procedures for ensuring that operations ridges and properly recorded. In such configuration, applications and users have no direct access to tables, but go through procedures stored pre-defined.