Answer Posted / ns

constraints are like an a right or any event which can we
apply on our table or column, or its an rule of integrity
there is an types of constraint:-
1.primary key
2.foreign key
3.unique
4.check
5.default
6.not null

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1098

---

How can we check the sql server version?

1125

---

Why olap is used?

1034

---

What are the types of table?

1028

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1195

---

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

1183

---

How to define the name and server for a new dsn?

1196

---

How to use linked server?

1269

---

Is truncate autocommit?

993

---

How do you create an execution plan?

1002

---

What is the data type of time?

1017

---

What is the difference between dropping a database and taking a database offline?

1218

---

What are user defined functions in ms sql server?

1064

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1051

---

What are the different types of locks in the database?

972

---