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


Please Help Members By Posting Answers For Below Questions

What are the different types of backups avaialabe in sql server 2005?

630


What is the meaning of lock escalation and why/how to stop this? : sql server database administration

609


What does top operator do?

572


What is the difference between varchar and nvarchar datatypes?

574


Explain syntax for viewing, dropping and disabling triggers?

510






What stored procedure can you use to display the current processes?

501


How do you troubleshoot errors in a SQL Server Agent Job?

565


Why we use functions in sql server?

522


What is mscorsvw.exe - process - microsoft .net framework ngen?

532


Do you know the capabilities of cursors?

535


Is truncate a dml command?

503


What is difference between oltp and olap?

580


Is there any difference between the primary key and unique key?

574


What is default constraint in ms sql server?

540


Can you explain important index characteristics?

531