Viewing 3 posts - 1 through 3 (of 3 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,...
December 29, 2003 at 10:11 pm
#488114
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...
November 24, 2003 at 5:25 am
#483312
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)...
October 16, 2003 at 5:13 am
#478420