what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 21454 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / anil patel
a. select * from Emp where null = null;
null= null is always false os no rows returns.
b. select * from Emp where 1=1;
it returns all rows
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is stretch database in sql server?
How can I add Reporting Services reports to my application?
What is single-user mode?
Comment,Datatypes are unlimited
What is the difference between migration and upgradation in sql server?
System requirements for sql server 2005 express edition?
What is user-defined scalar function?
How to use old values to define new values in update statements in ms sql server?
What do you mean by an execution plan?
What is an index. What are the types?
What are the differences between web role and worker role?
What is the maximum rows in sql server table?
role of sql sever 2005 in database rather than any other database
What is merge statement?
