To handle instances of data migration due to column renames, have you considered a mapping feature in SQL Compare? I believe there is something similar in SQL Data Compare...

Electronic media in general is harmed by existing patent/copyright laws - even going back to 14+14 for this area doesn't make sense given the fast pace of innovation & the...

When you're trying to update and select information at the same time, wouldn't it be simpler to use OUTPUT:

UPDATE dbo.Book

SET LastAccess = GETDATE()

OUTPUT INSERTED.Title, INSERTED.Author

WHERE BookId = @BookId

(I believe you...