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

Scripts with tag Stored Procedure Rss

Search for any content tagged stored procedure

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 7 of 7   
 

Template - Type 6 SCD Stored Procedure

Template to create a Type 6 slowly changing dimension stored procedure  Read more...
By Marie Bayer 2014/03/05 | Source: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 1,186 reads

SP Send Query Result as HTML table using DBMail

Create a stored procedure that will send the result of a query as an html table from the database mail.  Read more...
By Dave Gugg 2014/02/25 | Source: SQLServerCentral.com | Category: db_mail
Rating: |  Discuss |   Briefcase | 1,690 reads

Universal foreach aka sp_uforeach

This script is a universal foreach stored procedure. You can loop through everything with the help of if.  Read more...
By Robert Virag 2013/09/24 | Source: SQLServerCentral.com | Category: scripts
Rating: |  Discuss |   Briefcase | 1,527 reads

Find Stored Procedures and Functions That Reference Certain Tables

Find any code objects that interact with a given table/view, or call another given code object.  Read more...
By Hakim Ali 2013/08/02 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 2,501 reads

Last Accesses Stored Procedure

List of your Stored Procedures and when they were last accesses.  Read more...
By Jason Clements 2012/10/25 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 1,777 reads

Database_Object_Last_used_details

I have implemented following stored procedure which is providing the object wise last used date of all databases which is available in single instance.  Read more...
By Abhijit Shedulkar 2012/09/12 | Source: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 1,195 reads

Script to get an ordered list of all stored procedures with parameters

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.  Read more...
By Derek Colley 2012/08/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,011 reads
   Items 1 to 7 of 7