topic Re: Using EXEC with INSERT INTO in Operating System - HP-UX

Using EXEC with INSERT INTO

prandip — Thu, 15 May 2003 19:11:30 GMT

I am having problems inserting into a table from tuples returned through exec. Here's an example of the code:

INSERT INTO EXEC

e.g. INSERT INTO #temptbl EXEC tempproc

I get the error:
Incorrect syntax near the keyword EXEC

Kindly advice

Re: Using EXEC with INSERT INTO

Yogeeraj_1 — Thu, 15 May 2003 19:27:09 GMT

hi,

the correct syntax would be:

insert into select ...

hope this helps!

yogeeraj

Re: Using EXEC with INSERT INTO

prandip — Thu, 15 May 2003 19:39:26 GMT

Hi Yogeeraj,
Thanks again but i am aware of that. I want to use values returned from a stored procedure, hence my problem. Again SQL Server allows using EXEC after INSERT INTO. Sybase is again giving me a no-no. Kindly advice on a work around on the syntax if there exists one.

Revert

Prandip

Re: Using EXEC with INSERT INTO

Remigiusz_1 — Fri, 16 May 2003 05:42:55 GMT

HI!

If stored procedyre return one value:

declare @return int
exec @return =
insert into values(@return)

when stored procedure return more than one values you must define procedure to set values of its parameters

delcare @ret1 int, @ret2 int
exec @ret1 output, @ret2 output
insert into values (@ret1, @ret2)

:-) ..
on MS SQL Server should work
... sory my english !!

Re: Using EXEC with INSERT INTO

Remigiusz_1 — Fri, 16 May 2003 05:43:42 GMT

Re: Using EXEC with INSERT INTO

Remigiusz_1 — Fri, 16 May 2003 05:43:53 GMT

Re: Using EXEC with INSERT INTO

prandip — Fri, 16 May 2003 12:35:38 GMT

Thanks mate!! No problem on english i assure you. I guess this will suffice for me now. Thanks again!!