CREATE PROCEDURE [dbo].[PRO_Logout] AS
GO
UPDATE TABUser SET OnlineMinutes = OnlineMinutes + (datediff(n, LastOnlineTime, getdate()))或者:
CREATE PROCEDURE [dbo].[PRO_Logout] AS
GO
UPDATE TABUser SET OnlineMinutes = OnlineMinutes + (datediff(Mi, LastOnlineTime, getdate()))h
GO
UPDATE TABUser SET OnlineMinutes = OnlineMinutes + (datediff(n, LastOnlineTime, getdate()))或者:
CREATE PROCEDURE [dbo].[PRO_Logout] AS
GO
UPDATE TABUser SET OnlineMinutes = OnlineMinutes + (datediff(Mi, LastOnlineTime, getdate()))h
-->
(datediff(n, LastOnlineTime, getdate()))
(datediff("n", LastOnlineTime, getdate()))
-->
(datediff(n, LastOnlineTime, getdate()))
尽量少用双引号,有时候支持,有时候不行,
看看行不行,没有试过。