ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.how to increment number after inserting new value<pre class="brush: sql">declare @amt int set @amt = 2000 update accounts set balance = balance + @amt where accountid=21222</pre> <p>&nbsp;</p>https://www.aspforums.net:443/Threads/662887/how-to-increment-number-after-inserting-new-value/https://www.aspforums.net:443/Threads/662887/how-to-increment-number-after-inserting-new-value/Mon, 07 May 2012 01:37:07 GMT