SET NOCOUNT ON; UPDATE [Departments] SET [Name] = @p0 WHERE [DepartmentID] = @p1 AND [ConcurrencyToken] = @p2; SELECT [ConcurrencyToken] FROM [Departments] WHERE @@ROWCOUNT = 1 AND [DepartmentID] = @p1;