[1.16]求助冰风堡里钱的存储过程,应该是怎么样的 [复制链接]

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER proc AUTOWORK_BFBPAY
as
set nocount on
UPDATE BFB_INFO SET MONEY=MONEY+500000000,CENTS=CENTS+2000,LastPayDay=day(getdate())
where LastPayDay<>day(getdate())
and serverid in (select distinct ServerID from bfb_sbk)
set nocount off
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO