What are the type of joins? When do we use Outer and Self joins?
Answer Posted / shivanibehere
http://www.tomjewett.com/dbdesign/dbdesign.php?
page=jointypes.php&imgsize=medium
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of backups avaialabe in sql server 2005?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What does top operator do?
What is the difference between varchar and nvarchar datatypes?
Explain syntax for viewing, dropping and disabling triggers?
What stored procedure can you use to display the current processes?
How do you troubleshoot errors in a SQL Server Agent Job?
Why we use functions in sql server?
What is mscorsvw.exe - process - microsoft .net framework ngen?
Do you know the capabilities of cursors?
Is truncate a dml command?
What is difference between oltp and olap?
Is there any difference between the primary key and unique key?
What is default constraint in ms sql server?
Can you explain important index characteristics?