ASA中执行动态sql的语句是什么？

[bcboy]

我看了帮助，应该是 exectue immediate,但我在扫执行下面这个过程时却出错

drop procedure usp_test;

create procedure usp_test
as
begin
declare @sql varchar(255)
select @sql = "insert into c_option values ('v1',1,'test')"
execute immediate @sql
select * from c_option
end


在isql中执行 exec usp_test 出错，提示为：
Table or view not found: Procedure '@sql' not found
改为：
create procedure usp_test
as
begin
execute immediate "insert into c_option values ('v1',1,'test')"
select * from c_option
end
提示：Table or view not found: Procedure 'immediate' not found

[lgsdaly]

exec(@sql)