34,590
社区成员
发帖
与我相关
我的任务
分享
create table table_a
(
time_a datetime,
time_b datetime,
zhou1 bit,
zhou2 bit,
zhou3 bit,
zhou4 bit,
zhou5 bit
zhou6 bit,
zhouri bit
)
create proc product_update_It
@time_a datetime,
@time_b datetime,
@one bit,
@two bit,
@three bit,
@four bit,
@five bit
@six bit,
@seven bit
as
update Itime set time_a=@time_a,time_b=@time_b,zhou1=@one,zhou2=@two,
zhou3=@three,zhou4=@four,zhou5=@five,zhou6=@six,zhouri=@seven