Posted by Kevin on 07/25/05 15:52

When I use:
insert @FeatRequestStatus
exec @sqlPlan
It says "execute can be used as a source when insert into a table viarable"
"Kevin" <hua@lucent.com> wrote in message
news:dc2mgs$16f@netnews.proxy.lucent.com...
> When I declare a cursor,I use a variable to replace the sql statement:
> DECLARE rs CURSOR LOCAL FAST_FORWARD FOR
> @sqlPlan
> But it is not true.Who can correct for me.
>
> Another question is :
> How to execute a sql statement state by a variable "@sqlPlan" and
> insert the result to a table "@FeatRequestStatus"?
>
> I am a new hand of sql programming.Thank you very much for your help
>
>

• Next in forum: Using CASE .. WHEN to have 'dynamic' sort
• Prev in forum: Help on creating a user function.
• Thread view: Re: Help on creating a user function.

[Reply to this message]