Create Procedure « Store Procedure Function « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Store Procedure Function
  3. Create Procedure
1.Performing Data Manipulation: Adding a New Row
2.Returning a Single Result Set from a procedure
3.Check to see if a procedure exists
4.Define procedure to insert or update
5.Store Procedure: Returns the Customer record given a parameter of the ID
6.Store procedure: pre-check for the existence of the foreign key (RegionID) before attempting the insert
7.Processing Return Status Values
8.Return only one value from the procedure: without the use of an output parameter
9.Using Parameters




10.Stored Procedures as Parameterized Views
11.RECOMPILE(ing) a Stored Procedure Each Time It Is Executed
12.Stored procedure can be executed with the parameter and assigned value
13.Transaction in a procedure