create procedure PA
@PaCPHM varchar(12)
AS
delete from Table1 where cphm=@PaCPHM
delete from talbe2 where cphm=@PaCPHM
有问题吗??
@PaCPHM varchar(12)
AS
delete from Table1 where cphm=@PaCPHM
delete from talbe2 where cphm=@PaCPHM
有问题吗??
BEGIN
delete from Table1 where cphm=V_1;
delete from talbe2 where cphm=V_1;
END;
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 & "')"
就该能用了