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
- 24391 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
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Explain some stored procedure creating best practices or guidelines?
Explain can you implement data mining in ssrs?
What is attribute? : sql server analysis services, ssas
How we can refresh the view?
How to delete existing triggers using "drop trigger"?
What is sql server profiler trace data file?
What is after dml trigger?
what is difference between NULL and ISNULL in SQL Server 2008?
What do you understand by triggers and mention the different types of it?
what are isolation levels? : Sql server database administration
How to use order by with union operators in ms sql server?
what is spatial nonclustered index
What stored by the msdb? : sql server database administration
How to create a store procedure with encryption?
