Code is running fine normally but when I am trying to encrypt,This problem occure
ALTER TRIGGER [dbo].[UPDATE_Ta]
ON [dbo].[Ta] With Encryption
AFTER UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @CopfkShopNo INT
DECLARE @CopfkTerminalNo INT
DECLARE @CofkUserId INT
DECLARE @CoSerialNo INT
DECLARE @CopkReceiptNo INT
DECLARE @CopkReceiptDate SMALLDATETIME
DECLARE @CoRecTime SMALLDATETIME
DECLARE @CopkTypeOfRec VARCHAR(10)
DECLARE @CoShopName VARCHAR(50)
DECLARE @CoCustReferenceName VARCHAR(80)
DECLARE @CoCustRequisition VARCHAR(MAX)
DECLARE @CoCreditFlag BIT
-- Insert statements for trigger here
SELECT
@CopfkShopNo = CopfkShopNo,
@CopfkTerminalNo = CopfkTerminalNo,
@CofkUserId = CofkUserId,
@CoSerialNo = CoSerialNo,
@CopkReceiptNo = CopkReceiptNo,
@CopkReceiptDate = CopkReceiptDate,
@CoRecTime = CoRecTime,
@CopkTypeOfRec =CopkTypeOfRec
@CoCustReferenceName =CoCustReferenceName
@CoCustRequisition=CoCustRequisition
@CoCreditFlag=CoCreditFlag
FROM INSERTED
IF (@CoCreditFlag = '1')
BEGIN
IF EXISTS(
SELECT copfkShopno
FROM dbo.Tarec (nolock)
WHERE dbo.TaRec.copfkShopno=@CopfkShopNo
AND dbo.TaRec.copkTypeOfRec=@copkTypeOfRec)
BEGIN
Msg 102, Level 15, State 1, Procedure UPDATE_TaReceipt, Line 113
Incorrect syntax near 'BEGIN'.
DELETE FROM dbo.TaRec
WHERE dbo.TaRec.copfkShopno = @copfkShopno
AND dbo.TaRec.copkTypeOfRec = @copkTypeOfRec
END
INSERT INTO dbo.TaRec
(
CoProcessedDate,
CoProcessedTime,
CoCreditFlag,
CoFreeText,
CoInvoiceNo,
CoCustProjNo,
CoCredPayAmt,
CoBankPayAmt,
CoCashPayAmt,
CoCheqPayAmt,
)
VALUES
(
@CoProcessedDate,
@CoProcessedTime,
@CoCreditFlag,
@CoFreeText,
@CoInvoiceNo,
@CoCustProjNo,
@CoCredPayAmt,
@CoBankPayAmt,
@CoCashPayAmt,
@CoCheqPayAmt,
)
END
ELSE
BEGIN
IF (@copkTypeOfRec = 'PAY')
BEGIN
UPDATE dbo.TaRec
SET coZipFileName = @coZipFileName
WHERE dbo.TaReceiptInv.copfkShopno = @copfkShopno
AND dbo.TaReceiptInv.copkTypeOfRec = @copkTypeOfRec
END
END
END
Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@copfkShopno".
Msg 137, Level 15, State 2, Line 50
Must declare the scalar variable "@CopfkShopNo".
Msg 137, Level 15, State 2, Line 91
Must declare the scalar variable "@copkTypeOfRec".
Msg 137, Level 15, State 2, Line 94
Must declare the scalar variable "@coZipFileName".
Msg 102, Level 15, State 1, Line 102
Incorrect syntax near 'END'.