Answer Posted / kumari

Constraint are the rules enforced on data columns on table

types of constraints:

PRIMARYKEY
FOREIGN KEY
NOT NULL
UNIQUE KEY
CHECK
DEFAULT
Check

What is reportserver and reportservertempdb ?

107

---

What is faster join or union?

597

---

What is public role in sql server?

532

---

How do you migrate data from mssql server to azure?

151

---

How to delete all rows with truncate table statement in ms sql server?

485

---

---

What do you mean by data integrity?

597

---

What area unit the various kinds of info compression introduced in sql server 2008?

566

---

What type of locking occurs during the snapshot generation? : sql server replication

862

---

What is the datatype of rowid?

506

---

Explain syntax for viewing, dropping and disabling triggers?

500

---

what is a schema in sql server 2005? : Sql server database administration

510

---

Are all views updatable ?

718

---

How can I create a report based on a query? : sql server management studio

557

---

What are the system database in sql server 2005?

549

---

When to use null data driven subscription?

148

---