what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1;
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 cursor as data base object?
Why it is recommended to avoid referencing a floating point column in the where clause?
Explain try...catch with sql server?
Explain what stored procedure sp_replcounters is used for? : sql server replication
How does stuff differ from the replace function?
How to display a past time in days, hours and minutes?
What are the advantages of log shipping?
How do I find the sql server database version?
can any body tell me how to know the password of current user in sql server
How to drop an existing table?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the limitations/drawbacks or ssrs 2008 r2?
What is the difference between coalesce() & isnull()?
Explain trigger classes i.e. Instead of and after trigger?
How do I know if localdb is running?