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
- 24912 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
What is the difference between having clause and where clause in sql server?
Explain a checkpoint?
What is a DBMS, query, SQL?
What is bcp? When does it use?
Explain the concepts and capabilities of sql server?
What are constraints in microsoft sql server?
What is SQL Azure Firewall?
What are the advantages of the mirroring?
Why I am getting this error when dropping a database in ms sql server?
What is used to replicate sessions between instances in coldfusion clusters?
What is a fill factor?
How to create and drop temp table in sql server?
What are the different types of stored procedures?
Give main differences between "Truncate" and "Delete".
how to determine the service pack currently installed on sql server? : Sql server database administration
