Answer Posted / 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.

Which command is used for user defined error messages?

1007

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

930

---

What is merge join?

1124

---

What is transact-sql ddl trigger?

1043

---

How can I create a new template for import ? : sql server management studio

1022

---

Explain boyce and codd normal form(bcnf)?

888

---

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

964

---

Is INSTEAD OF trigger directly applicable to Table ?

957

---

Where sql server usernames and passwords are stored in a sql server?

930

---

How to list all field names in the result set using mssql_field_name()?

867

---

What is snapshot report?

151

---

what changed between the previous version of sql server and the current version? : Sql server database administration

954

---

What is difference between sql and sql server?

934

---

What are the types of joins in sql?

1055

---

What is the difference between clustered and non-clustered indexes in ms sql server?

932

---