Home Forums Article Discussions Article Discussions by Author Discuss content posted by Honza Mensdorff SELECT @local_variable RE: SELECT @local_variable

  • December 14, 2009 at 1:59 am

    #1091797

    Carlo Romagnano (12/14/2009)

    That isn't true.

    Count() return 0

    This is not true that "That isn't true" 🙂

    "SELECT COUNT" statement from your example returns a zero as a result, so the result contains one row. Thus the condition "the SELECT statement returns no rows" fails and the variable changes its value.