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
- 24406 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / m@ngesh
in the first query There is no records to show in output
box only show the column name Like empname, city, address
etc..
and the second query say that there is all records are to
be show.when query (1=1) will be satisfied on the table
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of using third-party tools?
Do you think BCNF is better than 2NF & 3NF? Why?
 Explain what is sql override for a source taLle in a mapping?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is the difference between clustered and a non-clustered index?
Explain the difference between functions and stored procedures in sql server?
What is the difference between for trigger and after trigger?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Difference between group by clause and having clause in SQL?
what is checksum in sql server.........???
What happens if an integer is too big for int date type?
What do we need queues in sql service broker?
Which language is supported by sql server?
Do you know what is xpath?
What is deploy, process and build? : sql server analysis services, ssas
