in first case it would response and it will show error and in second case

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

Question Posted / rohit

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

Please Help Members By Posting Answers For Below Questions

Sql server reporting services vs. Crystal reports.

131

What is merge?

1010

How many full-text indexes can a table have?

972

what are the new features in SSRS?

134

How do you manipulate data?

899

How to create median function?

164

How do I create a stored procedure in dbml?

999

What are the differences between char and varchar in ms sql server?

1058

explain how to create a new schema in a database? : Sql server database administration

1106

What are the different subsets of sql?

1547

How to create a ddl trigger using "create trigger" statements?

1125

how to create “alternate row colour”?

146

Explain the third normal form(3nf)?

938

What are cursors in ms sql server?

1173

What is a filestream?

988