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
- 24828 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / nitin yadav(9229430059)
A. Will give you no record because null have no value that
means no comparision between two nulls.
B.will give all row because 1=1 condision always true for
all rows.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to take backup bcp out for a column in table in sql server?
What is the difference between seek predicate and predicate?
How to invoke a trigger on demand?
Why we use the openxml clause?
Can a database be shrunk to 0 bytes, if not, why?
explain different types of cursors? : Sql server database administration
What are the mathematical functions supported by sql server 2005?
How to list all tables in the database using odbc_tables()?
Why use identity in sql server?
How retrieve field names from the table in SQL through JAVA code?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How self join is different from outer join?
Do you know what is sql service broker?
How to create an index on an existing table in ms sql server?
What is an index in sql?
