update Book
set Name = Name + ' ' + CAST( (SELECT count(*) FROM Book b WHERE Book.Name = b.Name AND Book.Id > b.Id) as VARCHAR(255) )

update Book
set Name = Name + ' ' + CAST( (SELECT count(*) FROM Book b WHERE Book.Name = b.Name AND Book.Id > b.Id) as VARCHAR(255) )
where Id in (SELECT b1.Id FROM Book b1, Book b2 WHERE b1.Name = b2.Name AND b1.ID > b2.ID)