请教调用存储过程
存储过程举例:
CREATE procedure PBModifyRestTime(@Masterid varchar(7)) asbegin update TBRestTimeDetail set StartTime ='2012-2-24 00:28:00' where masterid=@masterid endGO
update TBRestTimeDetail set StartTime = '2012-2-22 0:25:00'where masterid='Rest01000005' (所影响的行数为 1 行)
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=VB;Data Source=192.168.1.1"masterid = TxtMasteridconn.Execute "PBModifyRestTime 'masterid'"查了Masterid也有值?masteridRest01000005