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
- 24829 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
Explain the types of indexes.
How many instances per computer are there in sql server 2000?
How can you list all the table constraints in a database?
What is a mutating table error and how can you get around it?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What are the advantages of passing name-value pairs as parameters?
How to create prepared statements using odbc_prepare()?
What is enhanced database mirroring in sql server 2008?
Explain differentiate between a having clause and a where clause?
Difference between primary key and clustered index?
What happens when converting big values to integers?
What is table constraint?
What is entity data services?
What is the difference between indexing and hashing?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
