Default values in select query

Jan 7, 2013 at 10:59 AM

Hi,

I have following table

TABLE1

COL1      COL2       COL3

11          12            13

21          22            23

 

I want to execute query like this "SELECT getdate(),0,COL1,COL2,COL3 from TABLE1" and get date like this

07-01-2012    0      11       12        13

07-01-2012    0      21       22        23

 

thanks in advance.