Figure 1: Commands That SQL Server Ran in Example Profile Exercise

1 SELECT "dbo"."authors"."au_id" FROM "dbo"."authors" 1
SET implicit_transactions on
DECLARE @P1 int
SET @P1=NULL
2 EXEC sp_prepare @P1 output, N'@P1 varchar(11)', N'SELECT
   "au_id","phone"  FROM "dbo"."authors"  WHERE "au_id" = @P1', 1
SELECT @P1
sp_execute 10, '409-56-7008'
DECLARE @P1 int
SET @P1=NULL
3 EXEC sp_prepare @P1 output, N'@P1 char(12),@P2 varchar(11)',
   N'UPDATE "dbo"."authors" SET "phone"=@P1 WHERE "au_id" = @P2', 
SELECT @P1
sp_execute 11, '415 658-9932', '409-56-7008'
sp_execute 10, '648-92-1872'
sp_execute 11, '503 745-6402', '648-92-1872'
sp_execute 10, '238-95-7766'
sp_execute 11, '415 548-7723', '238-95-7766'
sp_execute 10, '722-51-5454'
sp_execute 11, '219 547-9982', '722-51-5454'
sp_execute 10, '712-45-1867'
sp_execute 11, '615 996-8275', '712-45-1867'
sp_execute 10, '427-17-2319'
sp_execute 11, '415 836-7128', '427-17-2319'
sp_execute 10, '213-46-8915'
sp_execute 11, '415 986-7020', '213-46-8915'
sp_execute 10, '527-72-3246'
sp_execute 11, '615 297-2723', '527-72-3246'
sp_execute 10, '472-27-2349'
sp_execute 11, '707 938-6445', '472-27-2349'
sp_execute 10, '846-92-7186'
sp_execute 11, '415 836-7128', '846-92-7186'
sp_execute 10, '756-30-7391'
sp_execute 11, '415 534-9219', '756-30-7391'
sp_execute 10, '486-29-1786'
sp_execute 11, '415 585-4620', '486-29-1786'
sp_execute 10, '724-80-9391'
sp_execute 11, '415 354-7128', '724-80-9391'
sp_execute 10, '893-72-1158'
sp_execute 11, '707 448-4982', '893-72-1158'
sp_execute 10, '267-41-2394'
sp_execute 11, '408 286-2428', '267-41-2394'
sp_execute 10, '807-91-6654'
sp_execute 11, '301 946-8853', '807-91-6654'
sp_execute 10, '998-72-3567'
sp_execute 11, '801 826-0752', '998-72-3567'
sp_execute 10, '899-46-2035'
sp_execute 11, '801 826-0752', '899-46-2035'
sp_execute 10, '341-22-1782'
sp_execute 11, '913 843-0462', '341-22-1782'
sp_execute 10, '274-80-9391'
sp_execute 11, '415 834-2919', '274-80-9391'
sp_execute 10, '724-08-9931'
sp_execute 11, '415 843-2991', '724-08-9931'
sp_execute 10, '172-32-1176'
sp_execute 11, '408 496-7223', '172-32-1176'
sp_execute 10, '672-71-3249'
sp_execute 11, '415 935-4228', '672-71-3249'
IF @@TRANCOUNT > 0
COMMIT TRAN
SET implicit_transactions off
sp_unprepare 10
sp_unprepare 11