What is SQL Stored Procedures?

[technika]

Hello, I have recently started to learn the SQL Database Language and while learning it I am not able to understand the concept of the Stored Procedures. I have tried to learn it, but I am not getting the concept behind it. So, if you are having any knowledge about it, then please provide help to me to know the exact concept behind the SQL Stored Procedures.

[opaper]

When any type of group of Transact-SQL statements compiled into a single execution plan then it is called as stored procedure. If you are making use of the Microsoft SQL Server 2000 then your stored procedures must return data in four ways below:

• Output parameters
• Return codes
• A result set
• A global cursor

[MindSpace]

Hi, if you are making use of the stored procedure in your sql then the Benefits of Stored Procedures are as below:

• Precompiled execution
• Reduced client/server traffic
• Efficient reuse of code and programming abstraction
• Enhanced security controls

[Modifier]

A stored procedure is a group of SQL statements that form a logical unit and perform a particular task, and they are used to encapsulate a set of operations or queries to execute on a database server. For example, operations on an employee database (hire, fire, promote, lookup) could be coded as stored procedures executed by application code. Stored procedures can be compiled and executed with different parameters and results, and they may have any combination of input, output, and input/output parameters. This simple stored procedure has no parameters. Even though most stored procedures do something more complex than this example, it serves to illustrate some basic points about them.

[Praetor]

Hello, if you want to create a stored procedure then you must need to make use of the query as given below:

CREATE PROCEDURE <procedure name>
@location <data-type>(<size>)
AS
SELECT <field name>.......
FROM <Table name>
WHERE <condition if any>

[Reegan]

Hello, if you are having knowledge of programming language then the Stored procedures in SQL Server are same as procedures in other programming languages which can perform the following for you:

• It can simply able to get the parameters provided by the input and can return you different values as a output.
• It can also contain the programming statements which have the ability to perform the operations on the database. It can also call other procedures.
• It can provide you success or failure of the procedure by calling procedure.
• It can provide you reason for your procedure execution failure.