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