tryupdate 终端日志
set 开始时间=37812.6070601852
From (select * from (select top 1 * from 终端日志 where 座号='0' and 终端号='' and 姓名= 'A1' and 学号 ='guest' and 结束时间 between 37812.6070601852 and 37813.6070601852 and 事件='OFF' order by 结束时间) where 开始时间 is null) as t
Where 终端日志.key = t.key -- key指终端日志表的关键字
set 开始时间=37812.6070601852
From (select * from (select top 1 * from 终端日志 where 座号='0' and 终端号='' and 姓名= 'A1' and 学号 ='guest' and 结束时间 between 37812.6070601852 and 37813.6070601852 and 事件='OFF' order by 结束时间) where 开始时间 is null) as t
Where 终端日志.key = t.key -- key指终端日志表的关键字
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货