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
How do I view a trc file?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
How to trouble shoot if unable to connect SQL Server
Define primary key?
How to change the password of a login name in ms sql server?
what is a transaction? : Sql server database administration
What do you mean by 'normalization'?
What is sql server profiler?
Explain the use of containers in ssis?
What is use of except clause? How it differs from not in clause?
What do you mean by data integrity?
Explain various On-Delete options in a DB table. Which is the default option?
What is join query?
How to connect php with different port numbers?
What are the types of database recovery models?