I'm writing a Window's Service that does alot of updating SQL Server via ADO.NET, and I need to figure out the best way to increment a number field by 1 for all records.
Printable View
I'm writing a Window's Service that does alot of updating SQL Server via ADO.NET, and I need to figure out the best way to increment a number field by 1 for all records.
VB Code:
UPDATE Table1 Set intNumber=intNumber+1
Sweet, it's that easy? I thought it kind of might be but I wasn't sure and couldn't find an example. Thanks.