Answer / preeti singh

xp_Sendmail

Answer / naveengoud

In SQL Server 2008 we have an Option called DATABASE MAIL, in earlier editions it is referred as SQL Mail.

using DATABASE MAIL we can send  notifying mails to the users/administrator.

Answer / paruva

Hi All For sending Email from Data Base U can Go through
this article.

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

Can you force a query to use a specific index?

0 Answers  

---

How to replace given values with null using nullif()?

0 Answers  

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

0 Answers  

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

Do you know what is fill factor and pad index?

0 Answers  

---

can an order by clause be used in a creation of a view?

0 Answers  

---

What command would you use to create an index?

0 Answers  

---

What is a SQL Server Temporary Table?

1 Answers   Wipro,

---