how to add 1 to the field

#1 (**permalink**) 02-29-2008, 08:23 AM

when i work with Aceess Db i have SQL statment that cout the visitor:

update Tbl1 set fldvisit = fldvisit +1 where fld2='abc'

when i move to SQL Server it's not working
what to do?

#2 (**permalink**) 02-29-2008, 08:23 AM

Hi

This should be ok! What is the error/problem?

Posting DDL and example data http://www.aspfaq.com/etiquett*e.asp?id=5006
will help others to re-create the problem.

John

"yuval" <yuvalbra@gmail.com> wrote in message
news:1115492012.471848.288840@g14g2000cwa.googlegr oups.com...
> when i work with Aceess Db i have SQL statment that cout the visitor:
>
>
> update Tbl1 set fldvisit = fldvisit +1 where fld2='abc'
>
>
>
>
> when i move to SQL Server it's not working
> what to do?
>

#3 (**permalink**) 02-29-2008, 08:23 AM

What does "not working" mean. Tell us the error message if any or post some
example code to reproduce the problem (CREATE, INSERT, UPDATE statements).

--
David Portas
SQL Server MVP
--

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode