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
- 24201 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / phani
In First case it will not return any rows. only the colum
names will be displayed.
In the second case all the records that are available in
the table will be displayed.
| Is This Answer Correct ? | 61 Yes | 1 No |
Post New Answer View All Answers
What are drillthrough reports?
What is acid db?
Explain how to integrate the ssrs reports in application?
Difference between uniqe index and uniqe constraint?
What is the difference between varchar and nvarchar?
Will sql server 2005 allow you to reduce the size of a column?
How global temporary tables are represented and its scope?
Explain transaction server distributed transaction?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are the steps to insert a table?
define and explain the differences between clustered and non-clustered indexes.
Explain the relational database management system (rdbms)?
Name some of the open source software that you can use in alternative to SSR?
What is acid properties?
What stored procedure would you use to view lock information?
