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 10 of 10   

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,144 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,356 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,701 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,483 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,865 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,290 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,074 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,601 reads

Find all Procedures, Views, Functions that have been renamed

Find all Procedures, Views, Functions that have been renamed with sp_rename where syscomments does not match.  Read more...
By David Hay 2009/08/17 | Source: | Category: sp_rename
Rating: (not yet rated) |  Discuss |   Briefcase | 775 reads

Simple Crosstab Procedure with Power

Create crosstab queries as easily as MS Access with a lot more power.  Read more...
By cgruel 2014/09/09 | Source: | Category: crosstab
Rating: |  Discuss |   Briefcase | 4,298 reads
   Items 1 to 10 of 10