Guest User

Untitled

a guest
Jul 17th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. Exec (@SQLScript)
  2. Print @SQLScript
  3. End
  4. GO
  5. GO
  6.  
  7. if obj is not null
  8. drop procedure
  9. go
  10.  
  11. CREATE PROC
  12. @al varchar(16),
  13. @rule varchar(128)
  14. END CATCH
  15. GO
  16. GO
  17.  
  18. If Exists (Select * From Table)
  19. Go
  20. Set @Start = DateAdd(m, 1, @Start)
  21. End
  22. GO
  23. GO
  24.  
  25. Exec (@SQLScript)
  26. Print @SQLScript
  27. End
  28. GO
  29.  
  30. if obj is not null
  31. drop procedure
  32. go
  33.  
  34. CREATE PROC
  35. @al varchar(16),
  36. @rule varchar(128)
  37. END CATCH
  38. GO
  39.  
  40. If Exists (Select * From Table)
  41. Go
  42. Set @Start = DateAdd(m, 1, @Start)
  43. End
  44. GO
Add Comment
Please, Sign In to add comment