Encrypt into database

if exists (select * from sysobjects where id = object_id('dbo.Reaffirm') and sysstat & 0xf = 4)

     drop procedure dbo.Reaffirm

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

/*######################################################################################################

USED:     reafffirmation of

FUNCTIONS USED:  master.dbo.fn_encrypt_aes(CAST(@DateSubmitted AS VARBINARY(64)), 'LOCAL_test_web', NULL, 256)

DATE          ID     SCR#            DESCRIPTION

----------    ---    -----------     -----------------------------------------------------------------------

2009.07.09    wdb                    created.

###########################################################################################################*/

CREATE PROCEDURE dbo.Reaffirm

       @SegmentID int

     , @FirstName varchar(50)

     , @LastName varchar(50)

     , @EmployeeID int

     , @Affirmed varchar(10)

     , @DateSigned smalldatetime

     , @DateSubmitted smalldatetime

     , @IsDeleted varchar(10)

AS

/*

exec dbo.Reaffirm 1, 'William', 'Benson', '23609', 'yeah', '12/25/2009', '12/24/2009', 'nope'

SELECT * from Reaffirmation WHERE lastname = 'Benson'

*/

INSERT INTO Business_Conduct_Reaffirmation.dbo.Reaffirmation (SegmentID, FirstName, LastName

          , EmployeeNumber, Affirmed, DateSigned, DateSubmitted, IsDeleted)

VALUES (@SegmentID

     , @FirstName

     , @LastName

     , @EmployeeID

     , @Affirmed

     , @DateSigned

     , master.dbo.fn_encrypt_aes(CAST(@DateSubmitted AS VARBINARY(64)), 'LOCAL_test_web', NULL, 256)

     , @IsDeleted)

GO

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS ON

GO