在插入语句中使用存储过程. [英] using Stored procedure in insert statement.

问题描述

我遇到一个问题....我编写了如下程序，需要在插入语句中调用它...

am having one issue.... i write a procedure like below, and need to call it in insert statement...

CREATE PROCEDURE P_NextSequenceNo
AS
SET NOCOUNT ON
DECLARE @iReturn int
BEGIN TRANSACTION
SELECT @iReturn = Sequence FROM dbo.EMPSEQUENCE
UPDATE dbo.EMPSEQUENCE SET Sequence = ( Sequence + 1 )
COMMIT TRANSACTION
SELECT @iReturn
RETURN @iReturn

然后，我必须在插入语句下面的SeqNoKey列中调用该函数.

And after that i have to call that function into below Insert Statement in place of SeqNoKey column.

Insert Into EmpSequence (InvoiceNo, column1, column2, column3)
select 'SeqNoKey ', b.value3, 0, a.value1, c.value4
from table1 a,
join table3 b on a.value1=b.value3
and join table2 c on c.value4 = a.value1

推荐答案

DECLARE @iReturn INTEGER

SET @iReturn=EXEC(P_NextSequenceNo)


Insert Into EmpSequence (InvoiceNo, column1, column2, column3)
select @iReturn , b.value3, 0, a.value1, c.value4
from table1 a,
join table3 b on a.value1=b.value3
and join table2 c on c.value4 = a.value1

这篇关于在插入语句中使用存储过程.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！