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
- 24311 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / nitin yadav(9229430059)
A. Will give you no record because null have no value that
means no comparision between two nulls.
B.will give all row because 1=1 condision always true for
all rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Sql server reporting services vs. Crystal reports.
How to test a dml trigger in ms sql server?
List out the differences between global and local temp tables in sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the difference between drop table and truncate table?
What is rolap and its advantage? : sql server analysis services, ssas
What is merge statement?
What is dbcc? Give few examples.
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How is sql server used?
Differentiate between a having clause and a where clause.
Can we install sql server 2016 on windows 7?
What is statement level trigger?
When would you use it?
Explain how does the report manager work in ssrs?
