I'm using the Northwind database in sql server 2008.
-- Janet Leverling
SET [Title] = 'Lawyer'
WHERE [EmployeeID] = 3
-- Robert King
SET [Title] = 'Doctor'
WHERE [EmployeeID] = 7
I have two update statements like this.
When I run them individually they work fine.
I want to put these in a stored procedure, so when I run the stored procedure both records get updated.
Is there a syntax to combine both these statements into one statement?