SQL Server QUERY + UPDATE

Question

我有一个非常困难的程序要做，也许你可以帮我？我知道这里有非常好的程序员...

USE [MuOnline]
GO
/****** Object:  StoredProcedure [dbo].[LiveMu_Transfer cashpoint to gem]  Script Date: 01/05/2015 01:29:03 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
    BEGIN 
    SELECT CashPoint FROM  [dbo].MuCashShop_DATA AS T
    UPDATE [dbo].MuCashShop_data SET CashPoint = i.CashPoint
FROM (SELECT CashPoint FROM  [dbo].MEMB_INFO) i 
JOIN MuCashShop_DATA ON i.CashPoint = MuCashShop_DATA.CashPoint
   UPDATE [dbo].MEMB_INFO SET CashPoint = '0'
END
SET NOCOUNT OFF 

问题：我想每 5 分钟运行一次，例如，我想从MEMB_INFO中获取CashPoint并将其插入MuCashShop_DATA.CashShop

它

运行正常，但问题是它不+计数。

在memb_info每小时添加一次现金点（1 个现金点），如果我更新mucashshop_data每个现金点都有 1 个现金点......我需要一个执行以下操作的查询：

UPDATE [dbo].MuCashShop_data 
SET CashPoint = CashPoint + i.CashPoint

请帮忙吗？:(

Answer 1

你不是刚刚回答了你自己的问题吗？

更改此内容：

UPDATE [dbo].MuCashShop_data SET CashPoint = i.CashPoint
 FROM (SELECT CashPoint FROM  [dbo].MEMB_INFO) i 
 JOIN MuCashShop_DATA ON i.CashPoint = MuCashShop_DATA.CashPoint

对此：

UPDATE m SET m.CashPoint = m.CashPoint + i.CashPoint
  FROM MuCashShop_DATA m inner join
   (
          SELECT CashPoint FROM  [dbo].MEMB_INFO
     ) i 
         ON i.CashPoint = m.CashPoint

Answer 2

当你

这样做时会发生什么。

SELECT CashPoint FROM  [dbo].MuCashShop_DATA AS T
UPDATE A
SET    CashPoint = A.CashPoint + i.CashPoint
FROM   [dbo].MuCashShop_data A
       JOIN [dbo].MEMB_INFO i
         ON i.CashPoint = a.CashPoint
UPDATE [dbo].MEMB_INFO
SET    CashPoint = '0'