Answer / nevual

Primary keys are the unique identifiers for each row. They
must contain unique values and cannot be null. Due to their
importance in relational databases, Primary keys are the
most fundamental of all keys and constraints. A table can
have only one Primary key.
Foreign keys are both a method of ensuring data integrity
and a manifestation of the relationship between tables.

Answer / sudarsan

Primary key is a unique id for each table. This prevents
duplication of records. Each table can have a single
primary key. They can be refrenced by any tables as a
foreign key.

Answer / jai prakash chauhan

Primary keys are by default clustered index.

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

What is policy based management (pbm)? : sql server database administration

0 Answers  

---

how many bits ip address consist of? : Sql server database administration

0 Answers  

---

Explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

---

How to tune a stored procedure?

6 Answers  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

How to change server name in sql server?

0 Answers  

---

What is Schema in Database?

1 Answers   Cap Gemini,

---

What is the command dbcc checkdb used for?

0 Answers  

---

how to connect sybase to sql server 2005?.

1 Answers   ABC,

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---