u can not compare two nulls null means nothing.so ANS 1:no row ANS 2:A

what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;

Question Posted / nitin yadav(nitin.yadav.india@

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

Please Help Members By Posting Answers For Below Questions

Can we shrink data file in sql server?

1048

what is the difference between Tabular and Matrix report?

170

What are the parts of a function?

936

What is sql server programming?

1040

Explain about the command-line tool SQLCMD?

1085

what is the difference between a primary key and a unique key? : Sql server database administration

994

What is the Disadvantage of indexed sequential file.

1078

Define right outer join in sql server joins?

1043

What is implicit mode in sql server?

1102

What is sql view?

1019

What are types of storage modes? : sql server analysis services, ssas

1032

How to search for a string in all stored procedure in sql server?

997

What is default constraint in ms sql server?

1032

can SSRS reports Cache results?

147

Explain about analysis services?

1046