SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 7, T-SQL, Stored Procedures, Advanced Querying Rss

   Items 1 to 2 of 2   

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 | 15,036 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,876 reads
   Items 1 to 2 of 2   
administration (1)    
performance tuning (1)    
triggers (1)