Database Reference
In-Depth Information
Figure 8-5. Row inserted in a transaction
6. Add another person with parameter values. Enter the following statement, and
execute it as you've done previously with other similar statements.
exec sp_Trans_Test 'Spark', 'Arshika ', null,'Agarw'
7. You should get the same results shown earlier in Figure 8-4 in the Messages
tab.
8. Try the SELECT statement shown in Figure 8-4 one more time. You should see
that Arshika has been added to the Person table. Both Vamika and Arshika
have no child records in the PersonDetails table.
How It Works
In the stored procedure, you define four input parameters:
 
Search WWH ::




Custom Search