how to add 1 to the field

#1

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

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 (AT) gmail (DOT) com> wrote

Quote:

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

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

how to add 1 to the field

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

how to add 1 to the field - 05-07-2005 , 01:53 PM

Re: how to add 1 to the field - 05-07-2005 , 01:57 PM

Re: how to add 1 to the field - 05-08-2005 , 05:39 AM