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
- 23815 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
Can one drop a column from a table?
Explain powershell included in sql server 2008?
wat wil hapn if we give the both read and deny read permission to user?
Describe in brief authentication modes in sql server.
What are the advantages of using stored procedures in sql server?
How to start and end transact-sql statements?
Where are sql server usernames and passwords stored in the sql server?
What is a trigger and types of a trigger?
Why main is user defined function?
What structure can you implement for the database to speed up table reads?
Is sql server implemented as a service or an application? : Sql server database administration
Can sub report data source be different from that of the parent report?
In which format does an image save in SQL Server database ?
How do we synchronize On-Premise SQL server with SQL Azure?
What is b tree index?
