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
- 24221 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
Can you roll back the ddl statement in a trigger?
What is the purpose of update statistics and scope_identity() function?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Explain what you mean by 3 tier architecture.
What is xdr?
How to handle error or exception in sql?
What is the tcp/ip port on which sql server runs?
What is the name of reporting services config file and what’s it’s used for?
What are sub reports?
How to reaname table name without using sp_Rename in sql server..?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is the cartesian product of the table?
what is the difference between a primary key and a unique key? : Sql server database administration
How do I install only the client tools of sql server 2000?
Do you know what is difference between stored procedure and user defined function?
