what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
- 13 Answers
- 20651 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / rohit
in first case it would response and it will show error and
in second case it will show object belonging to first row
and column
| Is This Answer Correct ? | 4 Yes | 29 No |
Post New Answer View All Answers
Explain what is log shipping?
Differentiate between truncate vs delete in mssql?
Why variables called the most powerful component of ssis?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is for xml in sql server?
Do you know the different ddl commands in sql?
What are the different types of subquery?
How do you delete duplicate rows in sql server?
What is field with example?
What are “phantom rows”?
What is normalization 1nf 2nf 3nf?
Do you know what is replace and stuff function in sql server?
In what sequence sql statement is processed?
can we have a nested transaction? : Sql server database administration
What is the difference between TRUNCATE and DROP?
