Cannot execute dynamic query in stored procedure

[Net]

Hi,

I'm using ADO.NET to execute a stored proc. The stored proc contains a
dynamic sql which will build the INSERT or UPDATE statement for execution at
the end of the stored proc.

I've a line that does some dummy inserts into a table before executing that
dynamic sql, like

exec ('INSERT INTO....')
exec (@sql)

The line of the INSERT INTO runs fine, but the stored proc just won't
execute the @sql. I tried to run the stored proc in the SQL Query Analyzer
and it works just fine.

Can anyone please help??

TIA.

Brgds,
Janet

[Andrew J. Kelly]

can you post the actual sp?

--

Andrew J. Kelly
SQL Server MVP


"Net" <bbahiru@mail.hongkong.com> wrote in message
news:ebRGHomQDHA.2320@TK2MSFTNGP12.phx.gbl...

> Hi,
>
> I'm using ADO.NET to execute a stored proc. The stored proc contains a
> dynamic sql which will build the INSERT or UPDATE statement for execution

at

> the end of the stored proc.
>
> I've a line that does some dummy inserts into a table before executing

that

> dynamic sql, like
>
> exec ('INSERT INTO....')
> exec (@sql)
>
> The line of the INSERT INTO runs fine, but the stored proc just won't
> execute the @sql. I tried to run the stored proc in the SQL Query

Analyzer

> and it works just fine.
>
> Can anyone please help??
>
> TIA.
>
> Brgds,
> Janet
>
>
>
>
>