Visual Studio Magazine

T-SQL | COMBINE UPDATE AND INSERT STATEMENTS

Listing 5. This procedure demonstrates a technique for combining an Insert statement and an Update statement into a single stored procedure. CREATE PROCEDURE STDA.CustomersUpdate @CustomerID NCHAR(5), ...
Ars Technica

MS SQL 2000/Access 2003 INSERT INTO Statement

I got it. The INSERT INTO was missing the draft status id field and also the name in the new table was still DRAFT_STATUS_ID but labeled Draft Status Id.