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

Content with tags Advanced Querying, Stored Procedures Rss

   Items 1 to 10 of 10   
 

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,740 reads

Self Eliminated Parameters

Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.   Read more...
By Alex Grinberg 2006/10/09 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 9,067 reads

How to Build Dynamic Stored Procedures

Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!   Read more...
By Robert Marda 2005/12/16 (first published: 2003/04/25) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 48,997 reads

Be Prepared - Part 2

Error handling in SQL Server 2000 is tricky. And it isn't the most robust system in the world. Stefan Popovski started a series on error handling using @@error and xact_abort. Here's the second installment of this series looking at error handling in nested stored procedures.   Read more...
By Stefan Popovski 2004/06/08 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 9,957 reads

How to Build Dynamic Stored Procedures

Robert is our expert on dynamic sql. This week he offers some good hints for planning the contruction of a proc that will use dynamic sql. He also adds some suggestions on how to format the code so that when you return to it later, you can figure out what you were doing!   Read more...
By Robert Marda 2005/12/16 (first published: 2003/04/25) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 48,997 reads

Default Values and Named Parameters for Stored Procs

Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer.   Read more...
By Andy Warren 2003/01/08 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,152 reads

DoEvents with SQL Server 2000 and Extended Procedures

In this article, we will leverage Extended Stored Procedures to extend the functionality of SQL Server and give a starting point to experiment with Extended Stored Procedures.   Read more...
By Herve Roggero 2002/08/26 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 6,206 reads

Creating your own sp_MSforeach stored procedure

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.   Read more...
By Brian Knight 2002/06/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,903 reads

Making Dynamic Queries Static

Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!   Read more...
By Leon Platt 2002/05/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 12,864 reads

SP_MSFOREACHDB - Getting a list of databases via TSQL.

Sp_MSforeachdb gives a DBA the ability to cycle through every database in your catalog. Find out how to use it.   Read more...
By Brian Knight 2001/05/31 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 13,216 reads
   Items 1 to 10 of 10   
 
Tags
t-sql (9)    
administration (2)    
miscellaneous (2)    
programming (2)    
sql server 7 (2)    
ado (1)    
dba (1)    
maintenance and management (1)    
performance tuning (1)    
sql server 2008 (1)    
triggers (1)    
visual basic 6 (1)