Answer Posted / manoj kumar

Contraint is a provision to limit or enforce the data in
the sql tables. It is of five types:-
1 Primary Key Constraint
2 Foreign Key Constraint
3 Unique Constraint
4 Not Null Constraint
5 Check Constraint

Write a query for primary key constraint with identity key word?

972

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1034

---

What is factless fact table? : sql server analysis services, ssas

963

---

What is co-related sub query?

975

---

What is after dml trigger?

954

---

Does full backup break log chain?

911

---

Please explain go command in sql server?

991

---

What is an index in sql?

959

---

What is the data tier application?

169

---

How do I trace a query in sql server?

900

---

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1162

---

How to download and install sql server 2005 books online?

1085

---

What is analysis service repository?

968

---

How to change a login name in ms sql server?

1024

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1059

---