Viewing 3 posts - 1 through 4 (of 4 total)
The same thing happened to me, that is, it said I got it wrong without ever having a chance to answer. I sent a message from the Contact Us page,...
Sloan
If you can't do it in SQL, get a bigger hammer!
December 29, 2003 at 10:11 pm
Am I missing something? Wouldn't creating an index on the three field in this query improve the performance more than using a clustered index, without the side effects and complications...
Sloan
If you can't do it in SQL, get a bigger hammer!
November 24, 2003 at 5:25 am
What you seem to really want is to match anything where the field supplied is null, and match the supplied string if not null:
CREATE PROCEDURE au_info
(
@lastname varchar(40) = null,
@firstname varchar(40)...
Sloan
If you can't do it in SQL, get a bigger hammer!
October 16, 2003 at 5:13 am
Viewing 3 posts - 1 through 4 (of 4 total)