服务器还没有运行的时候
点工具→在点分析查询器 运用以下命令(这样就可以把命令增加到触发器上了)
CREATE TRIGGER Exit_update ON [dbo].[TBL_Char]
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON
update TBL_Char
set FLD_MENOW = '101'
,[TBL_Char].FLD_X = '511'
,[TBL_Char].FLD_Y = '1028'
FROM Inserted
WHERE TBL_Char.FLD_NAME = Inserted.FLD_NAME and Inserted.FLD_Y='0'
end
以下命令在 查询里(没有分析哦 就查询里就可以了)
SELECT FLD_LEVEL AS Expr1, FLD_NAME AS Expr2, FLD_ID AS Expr3, TBL_Char.*
FROM TBL_Char
WHERE (FLD_NAME = 'ps灬铖埘乖') ←这里写上角色名称(对付单一角色使用)
SELECT FLD_LEVEL AS Expr1, FLD_NAME AS Expr2, FLD_ID AS Expr3, TBL_Char.*
FROM TBL_Char
WHERE (FLD_Y = '0') ←这里写上角色名称(对付角色使用)