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

Content with tag AutoGenerate Rss

   Items 1 to 3 of 3   
 

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 | 976 reads

AUTOGENERATE Stored procedures example

This is related to my other autogenerate code. this is just an example of how to use it.   Read more...
By Chris Morton 2008/11/21 | Source: SQLServerCentral.com | Category: autogenerate
Rating: |  Discuss |   Briefcase | 674 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,562 reads
   Items 1 to 3 of 3   
 
Tags
splog (2)    
stored procedures (2)    
chris morton (1)    
codrakon (1)    
create database (1)    
drop function (1)    
drop procedure (1)    
dynamic sql (1)    
information_schema.routines (1)    
insert (1)    
insert update select (1)    
metadata (1)    
parameters (1)    
select (1)    
update (1)