Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 25th, 2012  |  syntax: None  |  size: 0.95 KB  |  hits: 10  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Missing BEGIN and END? [closed]
  2. CREATE PROCEDURE ToBeDropped
  3. AS
  4. BEGIN
  5. PRINT 'Drop me!';
  6. END
  7. DROP PROCEDURE ToBeDropped;
  8.        
  9. SELECT m.[definition]
  10. FROM sys.sql_modules AS m INNER JOIN sys.objects AS obj
  11. ON m.object_id = obj.object_id
  12. WHERE obj.name = 'ToBeDropped';
  13.        
  14. EXECUTE ToBeDropped;
  15.        
  16. CREATE PROCEDURE ToBeDropped
  17. AS
  18. BEGIN
  19. BEGIN
  20. PRINT 'Drop me!';
  21. END
  22. DROP PROCEDURE ToBeDropped;
  23. END;
  24.        
  25. CREATE PROCEDURE ToBeDropped
  26. AS
  27. BEGIN
  28.     BEGIN
  29.         PRINT 'Drop me!';
  30.     END
  31.  
  32.     DROP PROCEDURE ToBeDropped;
  33. END ;
  34.        
  35. CREATE PROCEDURE ToBeDropped
  36. AS
  37. BEGIN
  38. PRINT 'Drop me!';
  39. END
  40. GO
  41. DROP PROCEDURE ToBeDropped;
  42.        
  43. CREATE PROCEDURE ToBeDropped
  44. AS
  45. BEGIN
  46. PRINT 'Drop me!';
  47. END
  48. DROP PROCEDURE ToBeDropped;
  49.        
  50. EXEC  ToBeDropped
  51.        
  52. EXEC  ToBeDropped
  53.        
  54. Msg 2812, Level 16, State 62, Line 1
  55. Could not find stored procedure 'ToBeDropped'.
  56.        
  57. CREATE PROCEDURE ToBeDropped
  58. AS
  59. BEGIN
  60.     PRINT 'Drop me!';
  61. END
  62. --Completes the procedure creation
  63. GO
  64. DROP PROCEDURE ToBeDropped;
create a new version of this paste RAW Paste Data