Error in Insert query in a table by executing one system proc in sybase

Question

I am getting error while inserting data inside table TableSizes with below query, Could anyone please help me in this regard.

declare @name varchar(256)
select @name ='TestTable'
begin
insert into workdb..TableSizes
exec sp_spaceused @name
end
go
Msg 156, Level 15, State 2
Server '<ServerName>', Line 5
Incorrect syntax near the keyword 'exec'.

Thanks in advance.

First, try running without any variables..`insert into workdb..TableSizes exec sp_spaceused TestTable` Since that does not work, I would question whether you can pass the output of a system stored procedure that way. — Mike Gardner, Sep 30 '13 at 12:40

score 0 · Answer 1 · edited Oct 01 '13 at 05:26

0

So what you are trying to do here is to insert a proc result set into a table, which is not allowed unless the table is a proxy table. If not, then complete the insert statement.

edited Oct 01 '13 at 05:26

Lance Roberts

22,383
32
112
130

answered Oct 01 '13 at 05:10

Gopal Sanodiya

3
3

Error in Insert query in a table by executing one system proc in sybase

1 Answers1