Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jesse McLain Annoying NULLs RE: Annoying NULLs

  • May 7, 2009 at 6:34 am

    #990287

    nits.shrivastava2006 (5/6/2009)

    Hi All, I got null value for the below statement

    set @val = null but for the below statement

    select @val = (select val from #empty) i got

    Invalid object name '#empty'

    Is it i have to declare #empty first ?

    The temporary table needs to be created first. Take a look at the code I posted earlier to see the declarations.

    LinkedIn: http://www.linkedin.com/in/sqlrv
    Twitter: http://www.twitter.com/sqlrv
    Website: http://sqlrv.com