Answer Posted / yashwanth

constraints are the rules enforced on data columns on a
table
use:constraints are used to limit the type of data that
can go in to a table

there are some constraints
a primarykey constraint
a unquekey constraint
a foreinkey constraint
a check constraint
a not null constraint
a default constraint

What is 2nf normalization?

1028

---

What is the web service used for reporting services?

123

---

How to name query output columns in ms sql server?

968

---

What is NOT NULL Constraint in sql server 2012?

1000

---

What is use of except clause?

1092

---

What is the use of keyword with encryption. Create a store procedure with encryption?

960

---

which table keeps the locking information? : Sql server administration

1092

---

Why do we partition data?

1028

---

What is join query?

893

---

Can you explain powershell included in sql server 2008?

939

---

What are the encryption mechanisms in sql server?

1028

---

Is the order of columns in the set clause important in ms sql server?

969

---

What is it’s similarity with sql server?

160

---

What is raid, and how it can influence database performance?

1056

---

Why should one not prefix user stored procedures with ‘sp_’?

1046

---