Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Annoying NULLs Expand / Collapse
Author
Message
Posted Thursday, May 7, 2009 6:34 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 2:26 PM
Points: 1,090, Visits: 541
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.



"...when ye are in the service of your fellow beings ye are only in the service of your God." -- Mosiah 2:17
Post #711964
Posted Monday, June 16, 2014 7:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:11 AM
Points: 2,382, Visits: 177
Thanks for the question.
Post #1581129
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse