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

Content with tags Stored Procedures, select Rss

   Items 1 to 3 of 3   
 

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED

I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database  Read more...
By Chris Morton 2013/01/08 | Source: SQLServerCentral.com | Category: autogenerate parameters
Rating: |  Discuss |   Briefcase | 3,059 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,605 reads

Create standard Get Procedure in T-SQL

This stored procedure saves time by creating a standard procedure to retrieve a row or set of rows.  Read more...
By Peter Strömblad 2008/09/02 | Source: SQLServerCentral.com | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 1,133 reads
   Items 1 to 3 of 3   
 
Tags
chris morton (2)    
codrakon (2)    
insert (2)    
metadata (2)    
update (2)    
3-tier design (1)    
autogenerate (1)    
autogenerate parameters (1)    
mkproc_get (1)    
parameters (1)    
resultset (1)