Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Alex Grinberg Self Eliminated Parameters RE: Self Eliminated Parameters
Bilal Dinc
Grasshopper
Points: 19
More actions
October 9, 2006 at 7:18 am
#664774
how is this technique all that clever? If anything, using
select *
from Customers
where customerid=isnull(@customerid,customerId)
is more efficient, easier to read and takes up less space.