我想给某个记录的字段加值,但总是失败。高手帮忙看一下!
我的存储过程是这样写的,请问高手为什么语法检查通过,调用存储过程后为什么没有给字段加值?
CREATE PROCEDURE [Score_SetScore]
(@TeamID [nvarchar],
@GoldenCount [int],
@SilverCount [int],
@CopperCount [int],
@ScoreCount [int])
AS UPDATE [games].[dbo].[Score]
SET [Golden] = [Golden]+@GoldenCount,
[Silver] = [Silver]+@SilverCount,
[Copper] = [Copper]+@CopperCount,
[Score] = [Score]+@ScoreCount
WHERE
( [TeamID] = @TeamID)
GO