Answer Posted / hari

Constraint : To Restrict the voilation of irrelegular data
and maintain data integrity.

Primary key
Unique Key
NotNull
Forigen Key
Check

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

955

---

what are isolation levels? : Sql server database administration

982

---

What are the types of stored procedures in an sql server?

981

---

What does normalization do to data?

1055

---

How to drop an existing user defined function in ms sql server?

1022

---

What is the concept of optimization?

1036

---

Explain the difference between control flow and data flow?

986

---

How to create a scrollable cursor with the scroll option?

992

---

How to defragment table indexes?

978

---

What is a cache in ssrs?

134

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1095

---

When should you use an instead of trigger?

948

---

Ways to improve the performance of a SQL Azure Database?

125

---

How to enter date and time literals in ms sql server?

1007

---

What is t-sql script to take database offline – take database online.

1075

---