Answer / Arvind Verma

In SQL Server, a HINT is a suggestion to the optimizer about how to execute a particular query. Hints can override the default optimization behavior in certain situations.

What is the difference between having clause and where clause in sql server?

1 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

Which institute is best for SQL Server 2005 Training?

6 Answers  

---

What are the pre-defined functions in the sql server?

1 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

1 Answers  

---

What is the difference between truncate and delete commands?

1 Answers  

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1 Answers   IBM,

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1 Answers   HCL,

---

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

---

what is the difference between a primary key and a unique key? : Sql server database administration

1 Answers  

---

how many non clustered index in sql server 2008,2010,2012

2 Answers   Accenture,

---