how many joins we can write if at all we have n no of
tables

Answer Posted / vamsi

n-1

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to execute a sql statement using mssql_query()?

718


What is attribute? : sql server analysis services, ssas

770


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

858


Which are new data types introduced in sql server 2008?

810


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

648






Explain syntax for dropping triggers?

701


What is the most common type of join?

726


How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

764


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

765


Would you store your query in a ssrs report or a database server? State the reason why?

132


Difference between drill down and drill through report.

731


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

747


What is tempdb database? : SQL Server Architecture

790


what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

709


Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

756