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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 insert problem

Author  Topic 

acdacd
Yak Posting Veteran

63 Posts

Posted - 2005-08-11 : 11:16:31
I have table as follow

TableA
ColA ColB ColC

All col is int. If I want to update colC value
ie. ColC = ColA * ColB

How to construct this query?

be a hardworking people!!

nosepicker
Constraint Violating Yak Guru

366 Posts

Posted - 2005-08-11 : 12:04:55
UPDATE TableA
SET ColC = ColA * ColB

Go to Top of Page
   

- Advertisement -