SQL Server > Stored Procedure

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

10 posts found
  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



Write for us






Hosting Recommendations