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

Content with tags Performance Tuning, Stored Procedures, Advanced Querying Rss

   Items 1 to 1 of 1   

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: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 12,873 reads
   Items 1 to 1 of 1