-
Recent Posts
Recent Comments
Archives
Categories
Meta
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