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
- 24924 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / poonam
First Query : will return all columns name without any data.
Second Query :will display all the records which are available in the table.bez Select* from emp where 1=1; the condition is true.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain transaction server implicit?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What are indexes in ms sql server?
What are four major operators that can be used to combine conditions on a where clause?
What are the new security features added in sql server 2012? : sql server security
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
Ms sql server index?
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 downside of using udf?
What is the cartesian product of table?
Write a query for primary key constraint with identity key word?
Who is the owner of a schema in ms sql server?
Do you know the isolation level that sql server support?
How to enter date and time literals in ms sql server?
What are different types of table joins?
