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
- 24349 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / gowthami radhakrishnan
a)in the first case there is no output only the column
names alone is displyed
b)in this case all rows will be displayed even for
1=1,2=2,3=3,..........
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is an index in a database?
What according to you is the difference between mysql and sql server performance?
What are key constraints?
How do you set a trace flag in sql server?
How do I find the port number for sql server?
What is SQL Azure Federations?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Explain about builtinadministrator?
State the difference between local and global temporary tables?
Is INSTEAD OF trigger directly applicable to Table ?
Explain the steps needed to create a scheduled job?
In what version of sql server were synonyms released?
Explain various On-Delete options in a DB table. Which is the default option?
Do you know nested transaction?
What do I need to start working with sql studio? : sql server management studio
