What is Sql Database Stored procedure how to use

Sql Database Stored procedure:

Stored procedure:

In this Post we are talking about Stored procedure in sql, how to create it's type and use also how to use with asp.net web application. if you want to learn asp.net programming then start from  introduction of asp.net and if you are new fir sql the see the post of sql introduction.
 .
In a Sql database management system (DBMS), a stored procedure is a group of SQL statements with an assigned name that's stored in the database in compiled form so that it can be shared by a number of programs.

A stored procedure is prepared SQL code that you save so you can re-use this code over and over again.  So if you think about a sql-query that you write over and over again, And having to write that query each time you would save it as a stored procedure and then use the stored procedure to execute the SQL code that you saved as part of the stored procedure.

Difference between Sql Stored Procedure and Function:

There are fallowing difference :-

• Sql Function must return a value but in Stored Procedure it can return zero or n values.

• Sql Functions can have only input parameters but Procedures can have input/output parameters.

• Sql Functions can be called from Procedure while Procedures cannot be called from Function.

• Sql Function can be embedded in a SELECT statement. But Procedures cannot be utilized in a SELECT statement.

• The most important feature of stored procedures over function is to retention and reuse the execution plan while in case of function it will be compiled every time.

• Functions that return tables can be treated as another rowset. This can be used in JOINs with other tables.

• Inline Function can be thought of as views that take parameters and can be used in JOINs and other Rowset operations.

• Exception can be handled by try-catch block in a Procedure whereas try-catch block cannot be used in a Function.

• We can go for Transaction Management in Procedure whereas we can't go in Function.

• Stored procedure allows modular programming.

• Stored Procedure can reduce network traffic.

• Stored procedures provide better security to your data.

Next Sql Stored Procedure topic:

• Different types of stored procedures

• Creating a simple stored procedure

• Using input parameters

• Using output parameters

• Using Try Catch

Sql Server Related Post:

• SQLServer questions for interview

• Overview of Sql

• Sql server while loop

• Continue Statement in sql

• SQL Parameter how to use in asp.net

• SQL-QUERY TYPES, ALIASES, JOINS, CLAUSES, FUNCTIONS

• Sql-determine the version and edition of SQL Server

• Different Types of SQL Server Stored Procedures

• SQL-Create Stored Procedure in SQL Server:

• SQL Server -Create Stored Procedure with Parameter

• How to Create Sql Function,
• SQL-Injection, prevent asp.net web application
• Sql server cursor declaration syntax example

• interview Part2

• interview Part3

• interview Part4

Asp.net-Checkboxlist related Post:

• Asp.net Checkbox List.

• Checkboxlist control in asp net

• Asp-checkboxlist control demo:

• Asp.net CheckBoxList using jQuery

• Asp checkboxlist Example using C#

• Asp.net checkboxlist control example

• Checkbox list Example using javascript

• Ckeck box list example using javascript.

• Checkboxlist in asp.net(control example)

• How to use CheckBox control in asp.net

• Validation checkbox control using JavaScript:

• Validation checkbox control using JavaScript

• How to check If checkbox Is checked in asp.net

• Example jQuery Validate on CheckBoxList using C#

• Check Uncheck all html CheckBoxlist controls using jQuery: