1,216
社区成员
发帖
与我相关
我的任务
分享
CREATE procedure PBModifyRestTime(@Masterid varchar(7))
as
begin
update TBRestTimeDetail
set StartTime ='2012-2-24 00:28:00'
where masterid=@masterid
end
GO
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 = TxtMasterid
conn.Execute "PBModifyRestTime 'masterid'"
查了Masterid也有值
?masterid
Rest01000005