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

Content with tag Stored Procedure Rss

   Items 1 to 11 of 11   

I Gotta See the Code

By Andy Warren 2014/06/16 | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,807 reads

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: | Category: template
Rating: |  Discuss |   Briefcase | 1,273 reads

Stored Procedure Boundaries

By Milos Radivojevic 2014/02/25 | Category: stored procedure
Rating: (not yet rated) |  Discuss |   Briefcase | 2,123 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: | Category: db_mail
Rating: |  Discuss |   Briefcase | 1,899 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,622 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: | Category: stored procedure
Rating: |  Discuss |   Briefcase | 2,553 reads

Using the SQL Server APP_NAME function to control stored procedure execution

In this tip we will look at one way to achieve control of stored procedures to ensure that reuse is for the intended purpose and changes do not break other applications that may be using this same code.  Read more...
By Additional Articles 2013/03/29 | Source: | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 3,838 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,827 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,248 reads

How to save results of a procedure with more than one result set

Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables  Read more...
By Pavel Sinkevich 2012/09/06 | Source: | Category: sqlclr
Rating: |  Discuss |   Briefcase | 10,041 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,042 reads
   Items 1 to 11 of 11   
t-sql (2)    
app_name (1)    
data dictionary (1)    
data warehouse (1)    
database mail (1)    
db_mail (1)    
foreach (1)    
function (1)    
html (1)    
last accesses (1)    
list (1)    
merge (1)    
multiple result sets (1)    
parameter (1)    
scripts (1)    
security (1)    
slowly changing dimension (1)    
sp_sproc_columns (1)    
sqlclr (1)    
template (1)    
text search (1)