SELECT (M1 + M2 + M3) AS Total FROM myTable
INSERT INTO myTable (M1, M2, M3, Total) VALUES (@M1, @M2, @M3, @M1 + @M2 + @M3)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)