GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Database  >  SQL Server

 Print  |  
Question:  How is the error handling in stored proc of T-SQL ?

Answer: 1 How is the error handling in stored proc of T-SQL
2 What is clustered index and non-clustered index? How many clustered indexes and non-clustered indexes can be created in one table?
3-what is disconnected mode?


July 07, 2008 13:12:16 #3
 suaveshiva   Member Since: July 2008    Total Comments: 1 

RE: How is the error handling in stored proc of T-SQL ?
 
Abt Clustered indexes:
V can hav only one clustered index in a table, by default primary key is termed as  clustered index.
V can have 249 non-clustered indexes in a table.
     

 

Back To Question