---

Search posts under SQL Server:

---

SQL Server > Stored Procedure

In this section we are going to learn about the Stored Procedure in the SQL server.

Stored Procedure

A stored procedure is a group of SQL statements compiled as one so that it can be reused again and again.

The difference between User defined functions (UDFs) and stored procedure is that, a Function must return a value however, a stored procedure may or may not return a value.

Read posts under SQL Server > Stored Procedure

1. Parameter less stored procedure to return data
2. Stored procedure that accepts parameters to fetch data
3. Execute a stored procedure from query window
4. Insert record stored procedure
5. update record stored procedure
6. Delete record stored procedure
7. Alter / Modify a stored procedure
8. Insert record and return identity column value
9. pagination stored procedure
10. Create stored procedure that accepts optional parameter