How many maximum tables we can join by using SQL JOIN??
 

Answer Posted / naveenpj

SQL server 2005 used to support up to 256 tables, with SQL Server 2008 the number joins that can be used is limited only to number of available resources.

Reference:  https://msdn.microsoft.com/en-us/library/ms143432.aspx

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the challenges you faced in your project (Testing) and in your company?

2685


What different types of manual testing are there?

743


Can you explain the workbench concept?

813


What is date driven testing?

762


Can anyone tell me about banking project? abt the transactions? the flow?

1610






how can you test the web environment for security testing?

1543


What is the Myers Boundary Table?

1644


9.Data – driver automation typically includes?

3003


hai friends, I need clarifications for some doubts in testing terminology. 1.What is thread testing. 2.What is bucket testing and which automated tool is used to do this test. 3. ERP testin automation testing. 4.What is Data Warehousing testing? 5.What is Implementation testing? 6.What is Shake out testing? please let me have the clarifications in detail

1666


what is TAS language which is used as a language for some projects/

1695


What is data flow diagram?

755


What r the things,u prefer and prepare before starting testing?

1901


What are the main key components in Web applications and Client Server applications? and their differences?

1580


Hello all, Can someone tell me what kind of questions i can expect from hiring manager along with two team members on final face to face interview for manual testing position.. I am switching from BA to QA as its better on benefits etc.. Thanks in advance

1571


What are the different levels of manual testing?

770