Update table problem - 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

Update table problem

Author

Topic

karthimathi
Starting Member

1 Post

Posted - 2008-02-29 : 01:36:46

I am having one database table in that i want to update two column fields.How to do it

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-29 : 01:41:25

[code]update abcTable
set a = 1, b = 2[/code]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

ranganath
Posting Yak Master

209 Posts

Posted - 2008-02-29 : 01:42:16

Hi,

Update TableName
set Col1 = @Col1,
Col2 = @Col2
where Condition

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-02-29 : 07:02:20

w3schools.com is the best for you

Vinod
Even you learn 1%, Learn it with 100% confidence.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-29 : 07:13:08

Hmmm, I thought SQLTeam was.

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources