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
- 24345 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
What happens if null values are involved in bitwise operations?
How does the report manager work in SSRS?
Explain data warehousing in sql server?
Where do you find the default Index fill factor and how to change it?
Write a SQL query to make a column as unique?
How to stop log file growing too big?
How to call stored procedure using http soap?
what is a check constraint?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is purpose of normalization?
How can sql server instances be hidden? : sql server security
Difference between connected and disconnected database in .net with sql server?
Explain filtered indexes?
What are parameterized reports?
What are pessimistic lock and optimistic lock?
