Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Update and a Counter
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Using Update and a Counter
Miscellaneous
Thread ID:
00417759
Message ID:
00417759
Views:
57
I need to update a record by record number...
Such as starting at 1215
and adding 1 for each record passsed

Can I do this in an update statement?
Ex.
Update journals set jnum = @Var1 = @Var1 + 1

TIA
Shawn
Shawn Dorion
Geo Sektor Dot Com
Website: http://www.geosektor.com

Web Hosting Plans
Visit : http://WebHosting.Applications4u.com/
Next
Reply
Map
View

Click here to load this message in the networking platform