I'm trying to insert two new columns into a table. But I'm also wanting to update the rows right afterwards, using a single statement.
So for example I want to add a SALARY and DOB column into the table. But I want to only update employee number 1 and number 3 with the new information information I have for in the rows.
Is it possible to do this in one statement? I don't believe it can be done without a stored procedure from what I've read up on.
Can someone help me out on this?