Answer Posted / g.rajesh(m.tech)

constrain kis a rule.
types of constriants are
1.domain constrain:
eg:chjeck,default,not null.
2.entity constraints:
eg:primary key.
unique key
3.referential constrain:
eg:foreign key

How to get the definition of a stored procedure back?

532

---

What is single-user mode?

524

---

Can we use custom code in ssrs?

593

---

What is use of dbcc commands?

629

---

What is the maximum size of column in sql server?

511

---

---

What is the most common type of join?

532

---

What is wide table?

542

---

Can you explain important index characteristics?

531

---

What is logshipping and its purpose?

573

---

How to loop through returning rows?

581

---

What is a dbms wizard?

621

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

600

---

What happens to a statement batch if there is a compilation error?

514

---

What is the security model used in sql server 2005?

514

---

What are the properties of sub-query?

585

---