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
- 24412 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / anil patel
a. select * from Emp where null = null;
null= null is always false os no rows returns.
b. select * from Emp where 1=1;
it returns all rows
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Where are stored procedures in sql server?
What does null mean?
what is the system function to get current user's user id? : Sql server database administration
How to concatenate two character strings together?
What are secondary xml indexes?
What is msdb database? : SQL Server Architecture
How to insert data into an existing table?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What is log shipping?
What is SQL Azure Data sync?
What are basics of policy management?
What are the export options of ssrs?
What is the command used to recompile the stored procedure at run time?
What happens if null values are involved in boolean operations?
Explain active/passive and active/active cluster configurations?
