Answer Posted / rev

3 basic types
1.entity constraint:
check
not null
null
2.domain constraint:
unique
primary
composite primary key
3.referential constraint:
integrity
foreign

What are commonly used odbc functions in php?

1009

---

Mention the different types of replication in sql server.

1014

---

Write a SQL query to delete a table?

1127

---

When do you think a developer should use sql server-based cursors?

1037

---

How to rebuild the master database?

1073

---

What is data compression? : sql server database administration

961

---

on line cluster can we make if yes tell me the procedure

2010

---

What are translations and its use? : sql server analysis services, ssas

1034

---

If we delete pack Spec what will be the status of pack Body ?

1469

---

Call by value and call by reference in procedure and function, with NOCOPY.

1289

---

How to convert numeric expression data types using the cast() function?

1055

---

What is the difference between insensitive and scroll cursor?

1152

---

What is lookup override?

1019

---

How you provide security to cube? : sql server analysis services, ssas

957

---

How do I view views in sql server?

995

---