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
- 24915 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 storage models of olap? : Sql server database administration
How to use go command in "sqlcmd"?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is an entity-relationship diagram (erd)?
What is difference between inner join and full join?
explain extended properties
What is table value parameters (tvp)?
What is sql server locking?
What is the return type of executeupdate ()?
Explain use of expression builder.
Name and describe few console utilities for ssrs?
What is the difference between a stored procedure and a user defined function?
Explain the truncate command?
How many types of schemas are there?
How to select some specific columns from a table in a query in ms sql server?
