数据库中
sta char(1),
time varchar(20)(存datetime类型的数据)
用游标计算出sta=0 与 sta=3 之间的时间差,然后存到临时表中timelist字段中,如何在存储过程里用游标实现呀?谢谢了,
再次感谢
sta char(1),
time varchar(20)(存datetime类型的数据)
用游标计算出sta=0 与 sta=3 之间的时间差,然后存到临时表中timelist字段中,如何在存储过程里用游标实现呀?谢谢了,
再次感谢
调试欢乐多
Declare @t1 datetime,@t2 datetime
@t1=(select convert(datetime,[time]) from tablename where sta=0)
@t2=(select convert(datetime,[time]) from tablename where sta=3)
Select datediff(day,@t1,@t2)
Declare @t1 datetime,@i int
Declare @t2 datetime,@t3 datetime
Declare cursor c1 scroll for
Select convert(datetime,[time]),sta from tablename
Open c1
Fetch first form c1 into @t1,@i
While @@fetch_status=0
Begin
If @i=0
Set @t2=@t1
If @i=3
Set @t3=@t1
Fetch next from c1 into @t1,@i
End
Close c1
deallocate c1select datediff(day,@t2,@t3)
id varchar(25),
passtime varchar(25),
) 插入到passtime字段里,如何处理呢,嘿嘿,还得麻烦你了,我太菜了,还得通过关联id,关联表为 flex_svc_statuslog,怎么写啊?