system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

What factors you will consider calculating the storage requirement for that view?

0 Answers  

---

Mention the command used to rename the database.

0 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

What is difference between equi join and inner join?

0 Answers  

---

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

How to remove duplicate rows from table?

0 Answers  

---

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

---

What is difference between drop truncate and delete?

0 Answers  

---

What is a NOLOCK?

3 Answers   NA,

---

What happens if ntwdblib.dll is missing on your machine?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---