home *** CD-ROM | disk | FTP | other *** search
/ distrib.akp.su/Programming/Vb-6+Rus/ / distrib.akp.su.tar / distrib.akp.su / Programming / Vb-6+Rus / COMMON / IDE / IDE98 / TMPLTS / DBITEM / NEWSPROC.SQL < prev    next >
Text File  |  1998-04-25  |  1KB  |  48 lines
  1. IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'Stored_Procedure_Name')
  2.     BEGIN
  3.         PRINT 'Dropping Procedure Stored_Procedure_Name'
  4.         DROP  Procedure  Stored_Procedure_Name
  5.     END
  6.  
  7. GO
  8.  
  9. PRINT 'Creating Procedure Stored_Procedure_Name'
  10. GO
  11. CREATE Procedure Stored_Procedure_Name
  12.     /* Param List */
  13. AS
  14.  
  15. /******************************************************************************
  16. **        File: 
  17. **        Name: Stored_Procedure_Name
  18. **        Desc: 
  19. **
  20. **        This template can be customized:
  21. **              
  22. **        Return values:
  23. ** 
  24. **        Called by:   
  25. **              
  26. **        Parameters:
  27. **        Input                            Output
  28. **     ----------                            -----------
  29. **
  30. **        Auth: 
  31. **        Date: 
  32. *******************************************************************************
  33. **        Change History
  34. *******************************************************************************
  35. **        Date:        Author:                Description:
  36. **        --------        --------                -------------------------------------------
  37. **    
  38. *******************************************************************************/
  39.  
  40.  
  41.  
  42.  
  43. GO
  44.  
  45. GRANT EXEC ON Stored_Procedure_Name TO PUBLIC
  46.  
  47. GO
  48.