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

Explain foreign key in sql server?

0 Answers  

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

How to provide values to user defined function parameters?

0 Answers  

---

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

---

Who is the owner of a schema in ms sql server?

0 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

What is use of except clause?

0 Answers  

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

How to resolve the orphan use problem? : sql server security

0 Answers  

---

What are “phantom rows”?

0 Answers  

---