Interested to Buy Any Domain ? << Click Here >> for more details...
what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 24925 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / nitin yadav(nitin.yadav.india@
u can not compare two nulls
null means nothing.so
ANS 1:no row
ANS 2:All row (because of 1=1 is always true for all rows)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is simple indexing method?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Do you know the isolation level that sql server support?
What are the different types of locks in the database?
What is the difference between for xml raw and for xml auto?
Tell me what is the stuff and how does it differ from the replace function?
Mention the different types of triggers?
what is the difference between openrowset and openquery?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How to convert numeric expression data types using the cast() function?
Describe in brief sql server monitoring ways.
What is role playing dimension with two examples? : sql server analysis services, ssas
Do you know what is difference between stored procedure and user defined function?
What is Command line parameters in PLSQL.?
