**Question: How many columns can be used with roll up or with cube command?**

**Answer**: 10 columns

**Question: How many clustered index can be created on the table?**

**Answer**: Only one clustered index can be created.

**Question: How many columns can be selected in a select statement?**

**Answer**: 4096 columns can be selected.

**Question: How many columns can be selected in an insert statement?**

**Answer**: 4096 columns can be inserted in an insert statement.

**Question: What level of nesting is possible for stored procedure?**

**Answer**: 32 levels on nesting is possible for SP.

**Question: What level of nesting is possible for sub Queries?**

**Answer**: 32 level of nesting.

**Question: What level of nesting is possible for Triggers?**

**Answer**: 32 level of nesting.

**Question: How many non-clustered indexes can be created on a table?**

**Answer**: 999 non clustered indexes can be created on table.

**Question: How many parameters can be provided to a stored procedure?**

**Answer**: 2100 parameters can be provided to a sp.

**Question: How many parameters can be provided to a UDF?**

**Answer**: 2100 parameters can be provided to an udf.

**Question: How many columns can be taken in update statement?**

Question: How many non-clustered indexes can be created on a table?

ReplyDeleteAnswer: 999 non clustered indexes can be created on table.

CAN U EXPLAIN THIS QUESTION PLEASE HOW U TOLD A TABLE HAVE 999 NON CLUSTERED INDEXES

Please read the below article and its for latest version of SQL Server

ReplyDeletehttp://msdn.microsoft.com/en-us/library/ms188783.aspx