Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PROCEDURE myGenericProc(int QueryNo, varchar genericParam1, ..., varchar genericParamN)
- BEGIN
- SWITCH queryNo
- CASE 1
- SELECT * FROM table1 INNER JOIN table 2 ON ...
- CASE 2
- DELETE FROM table 3 WHERE ...
- ...
- CASE n
- UPDATE table4 SET a=b WHERE ...
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement