what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
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
When would you use it?
what exactly sql injuction.how to overcome.....
how many triggers you can have on a table? : Sql server database administration
What are the types of sql server?
What are system databases into sql server (2005/2008) : sql server database administration
What are joins in sql and what are the different types of joins?
Explain something about security and SQL Azure?
What is oltp (online transaction processing)?
Explain various On-Delete options in a DB table. Which is the default option?
What is proper subset of candidate key?
What is query and its types?
When we should use and scope of @@identity?
what is spatial nonclustered index
What encryption security is available in sql azure?
What is clustered index