Answer Posted / haritha

constraint is a rule which can not be voilated by end users.
Different types of constraints are available.They are:-
1)default constraint:-which is used to define a default
value.
2)primary key:-the key which does not allows duplication
and null values.
3)foreign key:-the key used to refer primary key defined
field in another table and it allows duplication.
4)null:-which allows NULL values.
5)not null:-which does not allows NULL values.
6)unique key:-which does not allows duplication but allows
NULL values.

How to create a stored procedure with a statement block in ms sql server?

987

---

How to create a testing table with test data in ms sql server?

1014

---

What are the mathematical functions supported by sql server 2005?

996

---

what are different types of raid configurations? : Sql server database administration

994

---

Can we take the full database backup in log shipping?

898

---

Explain timestamp datatype?

911

---

How to choose all records from the table?

997

---

Give an example of why you would want to denormalize a database

924

---

Do you know what are the restrictions that views have to follow?

1015

---

Why we use the openxml clause?

955

---

Why do we use non clustered index?

1008

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

967

---

Explain full-text indexing?

916

---

What are filegroups in sql server?

1012

---

Why do we use functions?

855

---