what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
Answer Posted / phani
In First case it will not return any rows. only the colum
names will be displayed.
In the second case all the records that are available in
the table will be displayed.
| Is This Answer Correct ? | 61 Yes | 1 No |
Post New Answer View All Answers
Explain the architecture of ms sql reporting service?
How do I start sql server agent automatically?
What authentication modes does sql server support?
What do you mean by cardinality?
Does a sql server 2005 select statement require a from?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to sort query output in descending order in ms sql server?
What are the key configuration files for sql server reporting services ?
Explain the concepts and capabilities of sql server?
What is the default port for SQL Server over a firewall?
What are different replication agents and what's their purpose? : sql server replication
How will you add a dimension to cube? : sql server analysis services, ssas
Please explain go command in sql server?
What is 2nf example?
How can I check that whether automatic statistic update is enabled or not?