<div>
SELECT @Pub = RowPub FROM DBO.XXX_SecurityRight WHERE RightID=0;<br />
<br />

</div>


SELECT @Pub = RowPub FROM DBO.XXX_SecurityRight WHERE RightID=0;



<div>
the syntax SELECT INTO like you tried to use is Oracle Syntax, but you seem to be using SQL Server, looking at the error message.
</div>


the syntax SELECT INTO like you tried to use is Oracle Syntax, but you seem to be using SQL Server, looking at the error message.

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


Hi,

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'.

Regds.
~ HNS ~

select into

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.