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
- 24442 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / nitin yadav(nitin.yadav.india@
u can not compare two nulls
null means nothing.so
ANS 1:no row
ANS 2:All row (because of 1=1 is always true for all rows)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are parameterized reports?
What are the database objects? : SQL Server Architecture
List out what other servers you can use with ssrs?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What are different type of Collation Sensitivity?
What is a file group?
What is dbcc? Give few examples.
Why use “nolock” in sql server?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
How to verify a login name with sqlcmd tool?
If a table does not have a unique index, can a cursor be opened on it?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
how many triggers you can have on a table? : Sql server database administration
What is @@error in sql?
What are the steps you should follow to start sql server in single-user mode?
