asked on Where clause in stored procedure
Hello,
Ihave a where clause in SP ,is a better way of writing this :
Cheers
Ihave a where clause in SP ,is a better way of writing this :
WHERE(
[TravelDate] = @TravelDate OR
([TravelDate] is null AND @TravelDate is null) OR
([TravelDate] is null AND @TravelDate ='') OR
([TravelDate] ='' AND @TravelDate is null))
Cheers
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
Last Comment
RIAS
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Cheers!
ASKER
Will there be performance difference if I modify the Stored Procedure with
Cheers
WHERE ISNULL([TravelDate],'') = ISNULL(@TravelDate,'')
Cheers
I don't think so.
How long took the original solution and how long it takes after you used mine suggestion?
How long took the original solution and how long it takes after you used mine suggestion?
ASKER
Can't notice the difference,
Is it worth changing the original code then as I will have to modify nearly 100 Stored Procedures?
Is it worth changing the original code then as I will have to modify nearly 100 Stored Procedures?
I guess TravelDate is not indexed, right?
IMO doesn't worth the work. It's mostly code reduction than performance gain.
Take it as code tuning lesson ;)
IMO doesn't worth the work. It's mostly code reduction than performance gain.
Take it as code tuning lesson ;)
ASKER
Cheers!