Explain the dbcc pintable command when would you use it?

0 Answers  

---

How will u get 5 years back record?

5 Answers  

---

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 is denormalization? : Sql server database administration

0 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

---

What does select 1 mean?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

How to create a scrollable cursor with the scroll option?

0 Answers  

---

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

What stored by the master? : sql server database administration

0 Answers  

---