Answer Posted / mohib

there are two types of
constraints
1;holonomic
constraint
2;non-holonomic constraints

Give me any three differences between Truncate and Delete.

575

---

What is the use of set nocount on/off statement?

629

---

Explain Geography datatype in SQL Server

633

---

What is the maximum size per database for sql server express?

560

---

How to set a database state to offline in ms sql server?

543

---

---

Do you know what are different types of replication in sql server?

515

---

Can you type more than one query in the query editor screen at the same time?

579

---

What is the difference between grant and with grant while giving permissions to the user?

513

---

What is stored procedures?

548

---

What is the largest component inside a field?

534

---

How to write a query with an inner join in ms sql server?

554

---

What is provisioning, billing and metering, and connection routing concepts in the service layer?

94

---

How to select an exiting database using mssql_select_db()?

513

---

What is the concept of optimization?

573

---

Does sql server 2000 clustering support load balancing?

574

---