What is change data capture (cdc) feature?

0 Answers  

---

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

Can you index views?

0 Answers  

---

What is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What are approximate numeric data types in ms sql server?

0 Answers  

---

Detail about the hardware which is supported by SQL server?

0 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---

What is a trigger and types of a trigger?

0 Answers  

---

Magic Tables ?

2 Answers   Thomson Reuters,

---