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 is boundary value testing? Give an example.

703


I studied MBA, I want learn any softwarecourse, which course is better hadoop or testing tools(manual+selenium?)

1200


I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?

1670


Explain the difference between alpha testing and beta testing.

643


what the purpose of requirement phase

12405






How to derive test data from the design documents?

1578


What is date driven testing?

672


Define cause effect graphing?

679


Explain the components of a test plan?

679


What are tools of performance testing?

704


What is the main use of preparing traceability matrix and explain the real time usage?

735


How can write testcases on a code under development pls give asnwer

1535


What is Catapult Testing in E-Learning Domain?

4652


how to explain banking domain project in testing?

10288


What is your approach when requirements change continuously?

707