469,917 Members | 1,763 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

how to add 1 to the field

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?

Jul 23 '05 #1
2 7841
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" <yu******@gmail.com> wrote in message
news:11**********************@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?

Jul 23 '05 #2
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
--
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Lee | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.