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

When would you use it?

995

what exactly sql injuction.how to overcome.....

2546

how many triggers you can have on a table? : Sql server database administration

977

What are the types of sql server?

1054

What are system databases into sql server (2005/2008) : sql server database administration

1016

What are joins in sql and what are the different types of joins?

1014

Explain something about security and SQL Azure?

134

What is oltp (online transaction processing)?

1009

Explain various On-Delete options in a DB table. Which is the default option?

1468

What is proper subset of candidate key?

998

What is query and its types?

917

When we should use and scope of @@identity?

999

what is spatial nonclustered index

992

What encryption security is available in sql azure?

101

What is clustered index

1010