Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunil Chandurkar Writing Dynamic Stored Procedure RE: Writing Dynamic Stored Procedure
Carlo Romagnano
SSC-Insane
Points: 22599
More actions
June 1, 2009 at 12:56 am
#1002576
Old style to write the WHERE condition.
I prefer to build a string ONLY with the true condition; it's more performing.
In a complex WHERE with useless condition may lead to a BIG consume of resources.