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

How to drop existing views from a database in ms sql server?

736

---

Explain syntax for viewing, dropping and disabling triggers?

691

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1974

---

What is difference between count (*) and count column?

664

---

What does top operator do?

749

---

---

In how many ways you can invoke ssrs reports?

117

---

What is it’s similarity with sql server?

153

---

What are various aggregate functions that are available?

691

---

What happens to a statement batch if there is a compilation error?

698

---

Where views are stored in sql server?

723

---

Explain how many normalization forms?

752

---

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

796

---

How does stuff differ from the replace function?

738

---

Is ssrs support other database except ms sql server?

104

---

Explain error and transaction handling in sql server?

681

---