Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Stored Procedure Rss

   Items 1 to 20 of 21    Older >>
 

Create Procedure

By Adrian D'Ews 2015/11/04 | Category: stored procedure
Rating: (not yet rated) |  Discuss |   Briefcase | 1,755 reads

How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups  Read more...
By Stephan Calderon 2015/04/16 | Source: SQLServerCentral.com | Category: cluster analysis
Rating: |  Discuss |   Briefcase | 4,161 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: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,495 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: SQLServerCentral.com | Category: db_mail
Rating: |  Discuss |   Briefcase | 3,377 reads

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: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 2,151 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: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 4,302 reads

I Gotta See the Code

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

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: SQLServerCentral.com | Category: template
Rating: |  Discuss |   Briefcase | 2,151 reads

Stored Procedure Boundaries

By Milos Radivojevic 2014/02/25 | Category: stored procedure
Rating: (not yet rated) |  Discuss |   Briefcase | 2,171 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: SQLServerCentral.com | Category: db_mail
Rating: |  Discuss |   Briefcase | 3,377 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,706 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: SQLServerCentral.com | Category: stored procedure
Rating: |  Discuss |   Briefcase | 4,495 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: MSSQLTips.com | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 3,940 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,872 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,297 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: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 10,126 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,080 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,610 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: SQLServerCentral.com | Category: crosstab
Rating: |  Discuss |   Briefcase | 4,302 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: SQLServerCentral.com | Category: sp_rename
Rating: (not yet rated) |  Discuss |   Briefcase | 777 reads
   Items 1 to 20 of 21    Older >>
 
Tags
t-sql (3)    
app_name (1)    
cluster (1)    
cluster analysis (1)    
clustered index (1)    
crosstab (1)    
data dictionary (1)    
data mining (1)    
data science (1)    
data warehouse (1)    
database mail (1)    
db_mail (1)    
fnord (1)    
foreach (1)    
function (1)    
functions (1)    
google (1)    
html (1)    
indexing (1)    
last accesses (1)    
list (1)    
merge (1)    
multiple result sets (1)    
parameter (1)    
performance tuning (1)    
pivot (1)    
scripts (1)    
search (1)    
security (1)    
slowly changing dimension (1)    
sp_rename (1)    
sp_sproc_columns (1)    
sql server 2005 (1)    
sqlclr (1)    
statistics (1)    
syscomments (1)    
template (1)    
temporary tables (1)    
text search (1)    
unknown groups (1)    
views (1)