Saberware Blog 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 →