Adam Carr adamcarr
adamcarr
/ CRUD_SP_Generation.sql
Created
February 17, 2011 08:31
Generate CRUD stored procedures from tables in schema
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- ######################################################### | |
| -- Author: www.sqlbook.com | |
| -- Copyright: (c) www.sqlbook.com. You are free to use and redistribute | |
| -- this script as long as this comments section with the | |
| -- author and copyright details are not altered. | |
| -- Purpose: For a specified user defined table (or all user defined | |
| -- tables) in the database this script generates 4 Stored | |
| -- Procedure definitions with different Procedure name | |
| -- suffixes: | |
| -- 1) List all records in the table (suffix of _GetAll) |
NewerOlder