Answer Posted / krishna

constraints are use to maintain the relation between the two tables. sql contains the 5 types of constraints
1.primary key
2.foreign key
3.unique key
4.Not null
5.check

What are commonly used mssql functions in php?

1064

---

How to display a past time in days, hours and minutes?

1010

---

What is the difference between upgrade and migration in sql server?

1078

---

How do I view a stored procedure in sql server query?

918

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

893

---

How to download and install microsoft .net framework version 2.0?

1130

---

How to provide column names in insert statements in ms sql server?

1143

---

Explain full-text query in sql server?

987

---

What is the partitioning method?

1012

---

What is bit data type?

1020

---

What is importing utility?

977

---

what information is maintained within the msdb database? : Sql server administration

953

---

How to use column default values in insert statements in ms sql server?

1022

---

What is difference between standardization and normalization?

1083

---

What purpose does the model database server?

1085

---