how to add 1 to the field

[yuval]

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?

[John Bell]

Re: how to add 1 to the field

Hi

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

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

John

"yuval" <yuvalbra@gmail .com> wrote in message
news:1115492012 .471848.288840@ g14g2000cwa.goo glegroups.com.. .[color=blue]
> 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?
>[/color]

[David Portas]

Re: how to add 1 to the field

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
--