Monthly Archives: October 2012

SQL Server – Output comes in handy

I was looking for a single query that will snag a field, update it and return the new value.  I stumbled across the OUTPUT clause. Dim Sql As String = “Update ArControl Set NextCustomer = Right(’0000000′ + CONVERT(VARCHAR,NextCustomer + 1),7) … Continue reading

Posted in Uncategorized | Comments Off