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), ...
OK, I have a table of names. Lets say we want to do secret santa assignments for whatever reason. Code: --// Create our SOURCE table DECLARE @t1 TABLE ( id int, name nvarchar(16), scrambledOrderName ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results