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
- 24411 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / gowthami radhakrishnan
a)in the first case there is no output only the column
names alone is displyed
b)in this case all rows will be displayed even for
1=1,2=2,3=3,..........
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between dataadapter and datareader?
How to create new tables with "create table" statements in ms sql server?
What are the differences between decimal and float in ms sql server?
According to you what goes into making the best database administrator? : sql server database administration
What is the cartesian product of table?
How do I trace a query in sql server?
What are the different authentication modes in sql server?
When do you think a developer should use sql server-based cursors?
How we create SQL Server 2005 Reporting Services ? Give me Sample
How to create new tables with "select ... Into" statements in ms sql server?
Is natural join and equi join same?
What does it mean if @@cursor_row returns a negative number?
What are the properties of primary key?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is sql server management studio? : sql server management studio
