Query to rename colunm

[xoxoxoxoxoxox]

Hello, Is there anyway to append some value to colunm name? For example, i have table with 150 colunms and i want to do Select * and append today's date with each colunm name. So column1, column2... should display colunm1_112006, column2_112006 and so on etc. I'll appreciate any help. Thanks in advance.

[Rob Graham]

"select column1 as column1_112006,colum2 as column2_112006 from table1"

[xoxoxoxoxoxox]

I don't want to use keyword "as" for 150 columns. Is there any way to rename using "select *" ?

[Rob Graham]

Nope. You could build your query dynamically in a stored procedure (Use schema to get the column names). 150 column table doesn't sound like a good design...

[Paul Conrad]

Rob Graham wrote:

150 column table doesn't sound like a good design...

:omg::wtf: Normalization could be a good idea :rolleyes:

---

Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon