×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: John Hawk
Added: Nov 29, 2017 1:12 PM
Views: 5
Tags: no tags
  1. IF EXISTS (
  2.     SELECT *
  3.     FROM sys.objects
  4.     WHERE object_id = OBJECT_ID(N'[dbo].[SPROCNAME]')
  5.       AND TYPE IN (N'P', N'PC')
  6.     )
  7.   DROP PROCEDURE [dbo].[SPROCNAME]
  8. GO
  9.  
  10. SET ANSI_NULLS ON
  11. GO
  12. SET QUOTED_IDENTIFIER ON
  13. GO
  14.  
  15. CREATE PROCEDURE [dbo].[SPROCNAME]
  16. (
  17.         @Parm1 VARCHAR(MAX),
  18.         @Parm2 INT
  19. )
  20. AS
  21. BEGIN
  22.     SET NOCOUNT ON
  23.  
  24.     -- Begin Statements
  25.  
  26.         -- End Statements
  27. END
  28. GO
  29.