Update TimeStamp ( RowVersion )Column

Transact-SQL
1

Hi

Is there any work around for

updating

TableA = Row1 = TimeStamp ( RowVersion)
to
TableB = Row1 = TimeStamp ( RowVersion)

2

I'm not really clear what you're asking for, you'll need to provide a fuller example, DDL, sample data, etc.

In any case the timestamp/rowversion data type isn't directly updateable, and it's not really useful unless you're doing old-time change detection.

3

thanks Robert for your input

:+1: :+1:

4

It's true that SQL Server generates the timestamp/rowversion data type automatically; it cannot be changed by hand. Its primary applications are data change detection and concurrency control. It's quite useful for maintaining data versions or performing change detection, but it's not designed for business logic or direct updates.

5

thanks James
:+1: :+1: