Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Stored Procedures, AutoGenerate Rss

   Items 1 to 2 of 2   
 

DROP all stored procedures

This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.   Read more...
By Chris Morton 2009/03/13 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 978 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

use metadata to generate basic create procedure statements for insert update and select  Read more...
By Chris Morton 2008/11/21 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 3,586 reads
   Items 1 to 2 of 2   
 
Tags
chris morton (1)    
codrakon (1)    
drop function (1)    
drop procedure (1)    
information_schema.routines (1)    
insert (1)    
metadata (1)    
parameters (1)    
select (1)    
splog (1)    
update (1)