SQLServerSay I have table1 with sayID, X, Y.1, 1, 12, 2, 23, 3, 3I have an empty table2 with:ID, XX, YYI want to insert values contained in table1, but make an operation on X and y, say multiply X ...

INSERT INTO TestIdentityGaps (id, Description) VALUES (5, ‘Five Point One’) GO SELECT * FROM TestIdentityGaps Now you can see that the new rows have been inserted using the specified primary keys.