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 2:10 am

    #664749

    Or the use of the SQL standard COALESCE. Example:

    WHERE Column_Name=COALESCE(@Param_Name, Column_Name)