Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---

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,

---

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

What is lookup override?

0 Answers   Informatica,

---

What is field in algebra?

0 Answers  

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

What is difference between standardization and normalization?

0 Answers  

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---