Answer Posted / sivanagireddy.k

constraints nothing but condition on column in the table by using constraint checking process or validation pprocess has been done.

constraints are 6 tyes
1.unique
2.Not null
3.Primary key
4.Check
5.Default
6.Foreign key

types of level in constraints

column level
table level

send ur queries to this mail id rsivanagireddy@gmail.com

What is the purpose of grouping data in a report?

1013

---

How to list all triggers in the database with sys.triggers in ms sql server?

1125

---

How to configure odbc dsn with different port numbers?

1152

---

How can you ensure that the database and sql server based application perform well?

1124

---

What authentication modes does sql server support?

1149

---

What is data compression? : sql server database administration

1017

---

Explain what is the use of custom fields in report?

957

---

What is the main purpose of having conversation group?

947

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2186

---

What is the difference between TRUNCATE and DROP?

1188

---

Explain magic tables in sql server?

1103

---

What are indexes in ms sql server?

1115

---

Does sql server use t sql?

1071

---

What is the fastest way to permanently delete a 1 million row table named customers?

1327

---

How to modify an existing stored procedure in ms sql server?

1137

---