what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  

---

What is the difference between for trigger and after trigger?

0 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

Explain the dirty pages?

0 Answers  

---

What is tempdb in sql server?

0 Answers  

---

What are the 7 disadvantages to a manual system?

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

Name few of the dcl commands in sql?

0 Answers  

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

---

What are the restraints imposed on the table design by a merge replication?

0 Answers  

---