SQL Server Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 864 Page Views: 

What is the maximum number of tables and views allowed in a FROM Clause?



Posted By: Avi Date: 1 October 2010 12:22:08 PM
 Answer:

It has been ristricted to maximum of 16 tables and views.


Posted By: avibtech


Date: 1 October 2010 12:22:08 PM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image cnjDaP
Related Questions
SQL Server : Which NET-Libraries are not supported by named instances of SQL Server?

Which NET-Libraries are not supported by named instances of SQL Server?

Multiprotocol , Appletalk , or Banyan vines are the net Libraries supported by named instances. They....
Category: SQL Server Date: 10/1/2010 12:31:08 PM
SQL Server : Which performance monitor counter is used to show the memory used by the process?

Which performance monitor counter is used to show the memory used by the process?

The Performance Monitor Process: Working Set counter shows the amount ofmemory used by a process.
Category: SQL Server Date: 10/1/2010 12:30:08 PM
SQL Server : How many Logical tables are available in the triggers?

How many Logical tables are available in the triggers?

Whenever the triggers are used there exists two logical tables viz. Deleted table and Inserted table....
Category: SQL Server Date: 10/1/2010 12:29:08 PM
SQL Server : Which SQL Statement is used to show fragmentation information for data and indexes of the specified table?
SQL Server : When a table is create with a Primary Key, then what sort of integrity is maintained?

When a table is create with a Primary Key, then what sort of integrity is maintained?

Entity Integrity. As it defines the row as a unique entity for a particular table which is forced by....
Category: SQL Server Date: 10/1/2010 12:27:08 PM