Figure 2 prAPP_Get_SessionValues

  CREATE PROCEDURE prAPP_Get_SessionValues
    @sSessionKey UNIQUEIDENTIFIER
AS
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

    SELECT 
                s.sSessionKey,
                sd.sVariableName,
                sd.sValue,
                s.dtLastAccessDateTime
    FROM        tblSession s 
    INNER JOIN tblSessionData sd ON s.sSessionKey = sd.sSessionKey
    WHERE       sd.sSessionKey = @sSessionKey
    ORDER BY
                sVariableName

    -- Update the "Last Access Date/Time"
    EXECUTE prAPP_Update_Session @sSessionKey

Figure 3 prAPP_Update_Session FakePre-d0596561b85c4aeb9c3b5aaa1a446630-a8182b8056bd44ba8079c0e47503da14 Figure 4 CreateSession Excerpt FakePre-477279ef5d15447e9ee0f4d07a53808a-47bfae263d0e4719b891c58466c81199 Figure 5 The Encryption and Decryption Functions FakePre-d41454830b1c4a1ca8e94dd86c0c0fc9-e5a80485e6a540ccabe238b9f92fe6bd Figure 6 GetRecords FakePre-0e10dc0115df41368907a240c79174ab-3910cc4b24074a10b246ea21c6da12c4 Figure 7 The GetSelectedRecords Private Function FakePre-1d1f771ade804562a797a8691315e91b-2a703c9c306e4afeac335d40a5d6294a Figure 10 Connect.asp FakePre-b81da336d8cc4d2ebda696bb3ea42510-a0248922d4874aa29a267af16b0a5574 Figure 11 SomePage.asp FakePre-632a27d2b71744ff9c1f447c40e1acc5-bbd66023af3c40f1b52eaaaa7a8035e0