How to script database validations?
You can create another table with expected records value and each time compare both tables records.
for compare data between two table you can use SQL Data Compare of Redgate package.