22,210
社区成员
发帖
与我相关
我的任务
分享这个存贮过程怎么写?
有以下字段
Id
Username
PSW
TypeId
LastOnlineTime
OnlineMinutes
我想做一个存贮过程,自动把更新OnlineMinutes.
更新方法OnlineMinutes = OnlineMinutes + datediff("n", LastOnlineTime字段值, getDate())
请问怎么写?
Id
Username
PSW
TypeId
LastOnlineTime
OnlineMinutes
我想做一个存贮过程,自动把更新OnlineMinutes.
更新方法OnlineMinutes = OnlineMinutes + datediff("n", LastOnlineTime字段值, getDate())
请问怎么写?
...全文
请发表友善的回复…
发表回复
xiaocong1980 2003-02-20
- 打赏
- 举报
大概
create procedure cp_update
@OnlineMinutes int output,
@Username varchar(20)
as
update table set @OnlineMinute=OnlineMinutes = OnlineMinutes + datediff("n", LastOnlineTime字段值, getDate()) where Username=@Username
create procedure cp_update
@OnlineMinutes int output,
@Username varchar(20)
as
update table set @OnlineMinute=OnlineMinutes = OnlineMinutes + datediff("n", LastOnlineTime字段值, getDate()) where Username=@Username
CrazyFor 2003-02-20
- 打赏
- 举报
update table set OnlineMinutes = OnlineMinutes + datediff("n", LastOnlineTime字段值, getDate())
