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
- 23771 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / radhakrishnan
a) first statement return only table structure (with out
data)
Eg: empid empname
b) second statement return the structure with data.
Eg: empid empname
101 radha
102 krishnan
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain what is it unwise to create wide clustered index keys?
How to create percentile function?
How to list all tables in the database using odbc_tables()?
Can primary key be null?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How can you control the amount of free space in your index pages?
What types of Joins are possible with Sql Server?
What is delete query?
Explain the use of containers in ssis?
Can you pass expressions to stored procedure parameters?
How to retrieve error messages using mssql_get_last_message()?
Explain the stored procedure?
What is an execution plan? When would you use it?
What is inner join in sql server joins?
What is the difference between resultset and resultsetmetadata?
