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  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

Can you insert NULL in unique column?

0 Answers   MCN Solutions,

---

What is replication with database mirroring? : sql server database administration

0 Answers  

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

0 Answers   IGT,

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

Where are stored procedures in sql server?

0 Answers  

---