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
- 24195 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
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What are acid properties of transaction?
What is xml datatype?
What is database dimension? : sql server analysis services, ssas
Mention the differences between having and where clause.
What is the difference between clustered and a non-clustered index?
How to test a dml trigger in ms sql server?
What are the common performance issues in sql server?
Is it possible to create trigger on views?
How to get the definition of a trigger back?
What do you do in data exploration
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What is full outer join in sql server joins?
How raid can influence database performance?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
