Create SQL scripts for SP
Brought to you by:
xquantum
Menu
▾
▴
#6 Create SQL scripts for SP
SQL scripts should be generated for each stored procedure that are presented in "Forum" database.
Each script must contain the following parts:
1. Checking on SP existing. If SP is already exists, it must be dropped before creation.
2. "CREATE PROC" section with SP implementation.
Each SP must be saved in the SQL/SP folder in the project root directory. Script files must have the same names as SP have.
Also common script should be created. Please save it in "SQL" folder, call "StoredProcedures.sql". This script should contain all SP implementations (don't forget to use "go" transact-sql instruction between procedures and before checking for existing).