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
- 24214 Views
- Patni, I also Faced
- E-Mail Answers
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
Can two different columns be merged into single column? Show practically?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
What is ms sql server service broker?
Explain about remote stored procedure?
What is co-related sub query?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the usage of the sign function?
How can you check the version of sql server?
What is a functions and types in sql server?
How to insert new line characters into strings?
How to find related tables in sql server?
What are the instances when triggers are appropriate?
How to make remote connection in database?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is fill factor and pad index?
