Account for scope when writing stored procedures

(Arthur Fuller) A common problem in writing stored procedures arises when you need to insert one record into table T1 and one or more records into table T2, with the latter containing the PK of the row you just added to T1. Typically, this situation arises when you’re doing batch inserts into a pare

Read More - Register for Free Membership