Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Alex Grinberg Self Eliminated Parameters RE: Self Eliminated Parameters

  • October 9, 2006 at 12:27 am

    #664745

    If NULL is the default value used, the following construct can also be used:

    WHERE (Column_Name = ISNULL(@Param_Name, Column_Name))