Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Patrick LeBlanc SELECT and WHERE without FROM RE: SELECT and WHERE without FROM

  • June 24, 2011 at 8:55 am

    #1343730

    I wonder which of the following (if either) is more efficient:

    select @a = 1 where @b-2 = 0

    or

    if @b-2 = 0 set @a = 1