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 2015/02/17 | Source: | Category: template
Rating: |  Discuss |   Briefcase | 2,130 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 2015/03/26 | Source: | Category: db_mail
Rating: |  Discuss |   Briefcase | 3,332 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: | Category: scripts
Rating: |  Discuss |   Briefcase | 1,692 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 2015/04/10 | Source: | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,470 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: | Category: stored procedure
Rating: |  Discuss |   Briefcase | 1,863 reads


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: | Category: stored procedure
Rating: |  Discuss |   Briefcase | 1,284 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,071 reads
   Items 1 to 7 of 7