L
lym97230
Unregistered / Unconfirmed
GUEST, unregistred user!
我建了一个存储过程如下:
use pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'PAuthor' AND type = 'P')
DROP PROCEDURE PAuthor
GO
CREATE PROCEDURE PAuthor @name varchar(50)
as
select *
from authors
where au_lname in (@name)
编程时,我用了一个var str:string参数进行传值,其语句如下:
sqlstr:='EXECUTE PAuthor @custem='+str ;
qry.Close;
qry.SQL.Clear ;
qry.SQL.Add(sqlstr);
qry.Open ;
最后跟踪得到语句如下:
EXEC PAuthor @name='White','Green'
请问为什么不能这样执行,如何才能正确执行,请各位大侠赐教,万分感激!!!重赏!
use pubs
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'PAuthor' AND type = 'P')
DROP PROCEDURE PAuthor
GO
CREATE PROCEDURE PAuthor @name varchar(50)
as
select *
from authors
where au_lname in (@name)
编程时,我用了一个var str:string参数进行传值,其语句如下:
sqlstr:='EXECUTE PAuthor @custem='+str ;
qry.Close;
qry.SQL.Clear ;
qry.SQL.Add(sqlstr);
qry.Open ;
最后跟踪得到语句如下:
EXEC PAuthor @name='White','Green'
请问为什么不能这样执行,如何才能正确执行,请各位大侠赐教,万分感激!!!重赏!