t sql – Updating column value across all SQL server versions

I have a simple table with 3 columns

Installed by – some login name

Installed date
Date when bunch of scripts were run with any changes as part of that package

Version – version number when release was done

I am thinking below.

UPDATE Tablename
SET Version = '7.8.1' ;

In case above is not the correct way, How should I correctly update the version # column when release is done say when some scripts are installed today, version # needs to be updated lets say 7.8.1. Also this needs to work across all versions of SQL server from 2012 to 2019