query help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

query help

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-20 : 23:25:50

Dear All,
i've a table mytable with col1,col2,col3,col4....col9

the table is having all varchar(50) datatype.

now how can i put the data of col9 into col2? i need the data in col9 into col2. the table is having around 180 rows.

please help me in this regard

ranganath
Posting Yak Master

209 Posts

Posted - 2008-02-20 : 23:49:21

Hi,

try this

Update Table Tablename
Set Col2 = Col9

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-02-21 : 01:23:47

quote:
Originally posted by sunsanvin

Dear All,
i've a table mytable with col1,col2,col3,col4....col9

the table is having all varchar(50) datatype.

now how can i put the data of col9 into col2? i need the data in col9 into col2. the table is having around 180 rows.

please help me in this regard

What is your designation at the company you are working for?

Madhivanan

Failing to plan is Planning to fail

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-21 : 03:53:57

Dear Madhi,
sometimes, we may forget some thing, or we may not use several things regularly.at that time every human being forget something sometimes.I too felt very hard after remembering the basics. You should not Criticize someone based on one thing.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-02-21 : 04:01:34

quote:
Originally posted by sunsanvin

Dear Madhi,
sometimes, we may forget some thing, or we may not use several things regularly.at that time every human being forget something sometimes.I too felt very hard after remembering the basics. You should not Criticize someone based on one thing.

Well. I just wanted to know if you are front end/back end developer. No criticism at all