| SQL Server / T-SQL » Store Procedure Function » 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 |