Groups | Blog | Home
all groups > sql server (microsoft) > june 2005 >

sql server (microsoft) : Increment a single column?


Noozer
6/16/2005 9:04:39 AM
Just wondering if there is a simple way to do this...

I have an MS Access table that I'm using from an ASP page. It's quite
simple... Just one row with six columns. I want to be able to specify a
column and increment the value in that column.

Something like this.. I want to increment the value in column three:

UPDATE Counters Set [3] = [3]+1 ;

Thanks!


David Portas
6/16/2005 8:53:57 PM
[quoted text, click to view]

UPDATE Counters SET col3 = col3 + 1

--
David Portas
SQL Server MVP
--

AddThis Social Bookmark Button