what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 20608 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnan
a) first statement return only table structure (with out
data)
Eg: empid empname
b) second statement return the structure with data.
Eg: empid empname
101 radha
102 krishnan
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the partitioning method?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the Disadvantage of indexed sequential file.
Do you know query execution plan?
How many levels of sp nesting is possible?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is the difference between set and select?
where the connection string store in the database
what is sql server? : Sql server database administration
Explain about system database?
How to join two tables in a single query in ms sql server?
What is sql server locking?
how will add additional conditions in sql?
Explain error and transaction handling in sql server?
Why we should not use triggers?
