Reputation: 746
I am able to convert rowversion column in a table to varchar using below code
select CONVERT(VARCHAR, CONVERT(BINARY(8), roversion_col), 1) rwa from TBL
How do I convert it back to rowversion datatype? Is it NOT possible to do so?
Update:
This should not be treated as duplicate with
How to convert TIMESTAMP values to VARCHAR in T-SQL as SSMS does?
That question is about asking rowversion datatype to varchar. However, this question is vice-versa and wanted to get rowversion data using varchar.
Upvotes: 1
Views: 2831