why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What do you understand by triggers?

0 Answers  

---

---

What is log cache in sql server?

0 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

Explain mixed authentication mode of sql server?

0 Answers  

---

What type of Index will get created after executing the above statement?

0 Answers  

---

What are different types of table joins?

0 Answers  

---