|
|
Posted by Hugo Kornelis on 09/30/12 11:26
On Mon, 12 Sep 2005 13:56:43 GMT, vassone wrote:
(snip)
>The code I'm using is below and this keeps giving me "Multiple-step OLE DB
>operation generated errors. Check each OLE DB status value, if available. No
>work was done."
Hi vassone,
Try adding the command
SET NOCOUNT ON
as first command in the stored procedure (i.e. directly after the AS
keyword, before the INSERT)
CREATE PROCEDURE name
@parm datatype [OUTPUT],
...
AS
SET NOCOUNT ON
INSERT INTO table (...)
VALUES (...)
SET @output_var = SCOPE_IDENTITY()
GO
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Navigation:
[Reply to this message]
|