Advertisement
Guest User

Untitled

a guest
Mar 30th, 2015
250
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. PROCEDURE myGenericProc(int QueryNo, varchar genericParam1, ..., varchar genericParamN)
  2. BEGIN
  3. SWITCH queryNo
  4. CASE 1
  5. SELECT * FROM table1 INNER JOIN table 2 ON ...
  6.  
  7. CASE 2
  8. DELETE FROM table 3 WHERE ...
  9. ...
  10.  
  11. CASE n
  12. UPDATE table4 SET a=b WHERE ...
  13. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement