我写了一个存储过程，有一个参数，请问该如何调用？

[HelpLearnVC]

create procedure PA
@PaCPHM varchar(12)
AS
delete from Table1 where cphm=@PaCPHM
delete from talbe2 where cphm=@PaCPHM


有问题吗？？

[beckhambobo]

不懂sql server

[skywolfstars]

create procedure PA(V_1 VARCHAR2 ) AS
BEGIN
delete from Table1 where cphm=V_1;
delete from talbe2 where cphm=V_1;
END;

[bzszp]

没看出有什么错误
加上go
运行试试

[HelpLearnVC]

skywolfstars() 如何调用能？？

[skywolfstars]

1:
SQL>EXECUTE PA('V_1');

2:
SQL>BEGIN PA('V_1'); END;

[双子涂鸦]

好像有问题的
应该
create procedure PA
@PaCPHM varchar(12)
AS
delete from Table1 where cphm=@PaCPHM;
delete from talbe2 where cphm=@PaCPHM
go
然后在vb中
conn.execute "exec pa('" & yourpar & "')"
就该能用了