Viewing 2 posts - 1 through 3 (of 3 total)
Not sure if your specific requirements and the approach I've used before mesh, but here's how I've used optional parameters in a WHERE clause before.
CREATEPROCEDURE spOptionalParam
...
“In anything at all, perfection is finally attained not when there is no
longer anything to add, but when there is no longer anything to take away.”
Saint-Exupéry
Wind, Sand, and Stars
October 29, 2003 at 7:15 am
I found this snippet in the SQL Books Online, SP3 version, in the reference for LIKE:
It is recommended that LIKE be used when you search for datetime values, because datetime...
“In anything at all, perfection is finally attained not when there is no
longer anything to add, but when there is no longer anything to take away.”
Saint-Exupéry
Wind, Sand, and Stars
July 30, 2003 at 7:22 am
Viewing 2 posts - 1 through 3 (of 3 total)