Answer / unknown

If for any table, we have more than one primary key, viz If
the table can be uniquely identified by the help of more
than one attribute, the collection is called 'Composite
Key'. If only one key can act as the unique key, it is the
Primary key, rest of the keys are called alternate keys.
Individual keys of the composite key are the candidate keys.

Answer / mustafa

How do we specify an ALTERNATE KEY while creating a table?

Answer / jheelum

A CANDIDATE KEY ISA PRIMERY KEY. OTHER ARE ALTERNATE KEY

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

0 Answers   Cap Gemini,

---

How much is a sql server license?

0 Answers  

---

How you can change a cross join into an inner join?

0 Answers  

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

0 Answers  

---

Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?

2 Answers  

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---

How to optimize stored procedure optimization?

0 Answers  

---

What is a transact-sql statement batch in ms sql server?

0 Answers  

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

0 Answers  

---

your distribution database is full what will u do

0 Answers  

---

How do we rollback the table data in SQL Server

3 Answers  

---

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

2 Answers  

---