Posted on 2006-10-27
I used below stmt, its giving error. Could any one let me know.
DECLARE @Pub CHAR(10);
SELECT RowPub into @Pub FROM DBO.XXX_SecurityRight WHERE RightID=0;
Whats wrong in the above stmt. I am using above line of code inside my After insert trigger.
Error is as:
Msg 170, Level 15, State 1, Server SYS_034, Procedure TI_SecurityRight, Line 14
Line 14: Incorrect syntax near '@Pub'.
~ HNS ~