Всем добрый день.

Скажите мне, почему в этом скрипте в 30 и 31 строке генерится Incorrect syntax?


1>
2>
3> CREATE TRIGGER b.NEW_COMP ON b.COM_REQ
4> For INSERT AS
5>
6> BEGIN
7>
8> DECLARE @a_msg_id int
9> DECLARE @a_msg_pri int
10> DECLARE @a_msg_exec_ord int
11>
12> DECLARE C1 CURSOR FOR
13> SELECT
14> A_MSG_ID,
15> A_MSG_PRI,
16> A_MSG_EXEC_ORD
17> FROM ins
18>
19> OPEN C1
20>
21> FETCH C1 INTO
22> @a_msg_id,
23> @a_msg_pri,
24> @a_msg_exec_ord
25>
26> CLOSE C1
27> DEALLOCATE CURSOR C1
28>
29>
30> IF @a_msg_pri IS NULL BEGIN SET @a_msg_pri=0 END
31> IF @a_msg_exec_order IS NULL BEGIN SET @a_msg_exec_ord=0 END
32>
33> UPDATE b.COM_REQ
34> SET
35> A_TIME_CR = GETDATE(),
36> A_TIME_UPD = GETDATE(),
37> A_MSG_PRI = @a_msg_pri,
38> A_MSG_EXEC_ORD = @a_msg_exec_ord
39>
40> WHERE A_MSG_ID = (SELECT A_MSG_ID FROM ins)
41>
42> END
43>
44>
Msg 102, Level 15, State 1:
Server 'SD5', Procedure 'b.NEW_COMP', Line 30:
Incorrect syntax near '@a_msg_pri'.
Msg 102, Level 15, State 1:
Server 'SD5', Procedure 'b.NEW_COMP', Line 31:
Incorrect syntax near '@a_msg_exec_ord'.

Спасибо.