Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  

---

what are the disadvantages of cursors? : Sql server database administration

0 Answers  

---

What is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

---

Can you explain what is the use of custom fields in report?

0 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

---

is there a column to which a default can't be bound? : Sql server database administration

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

What is key attribute?

0 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

Which tcl commands are available on the sql server?

0 Answers  

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---