April 16, 2009 at 5:19 am
I even tested for all the options and all came null, even adding the value to the variable.
April 16, 2009 at 6:37 am
harsha.bhagat1 (4/16/2009)
I even tested for all the options and all came null, even adding the value to the variable.
Check out the code that I posted last week and compare it to yours.
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
May 1, 2009 at 2:43 pm
All the queries should return NULL.
Also I tested and the result it's the same.
May 1, 2009 at 2:47 pm
Mauricio Morales Soto (5/1/2009)
All the queries should return NULL.Also I tested and the result it's the same.
You have to reset the variable to -1 before each test. See the code I posted earlier.
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
May 7, 2009 at 6:34 am
nits.shrivastava2006 (5/6/2009)
Hi All, I got null value for the below statementset @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: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply