CREATE TRIGGER [song] ON [dbo].[TBL_Char]
after Insert
as
Update [TBL_Char] set [TBL_Char].FLD_ITEM=0x029402000000000037DC143C01000000000000000000000000000000000000000000000000039402000000000037DC143C01000000000000000000000000000000000000000000000000049402000000000037DC143C01000000000000000000000000000000000000000000000000E78802000000000037DC143C01000000000000000000000000000000000000000000000000E88802000000000037DC143C01000000000000000000000000000000000000000000000000E68802000000000037DC143C01000000000000000000000000000000000000000000000000B4C90100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000056D10100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B5C90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B6C90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B7C90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000ACC90100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B9C90100000000002CDC143C01000000000000004052D777C8F7CB3C0000000000000000005BD10100000000002CDC143C01000000000000004052D777C8F7CB3C0000000000000000005AD10100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000B8C90100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000054D10100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000ADC90100000000002CDC143C01000000000000008649D777C8F7CB3C0000000000000000006BBA02000000000094CA9A3B0F270000000000000000000000000000000000000000000000E76202000000000095CA9A3B0F270000000000000000000000000000000000000000000000F6D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000E26A1100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F5D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F7D00100000000002DDC143C01000000000000004052D777C8F7CB3C0000000000000000000F721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000010721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000011721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000012721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000013721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000014721100000000002CDC143C01000000000000004052D777C8F7CB3C00000000000000000029BC02000000000041EEF8050100000000000000000000000000000000000000000000000041BC02000000000041CFEE0B010000000000000000000000000000000000000000000000004BBC02000000000041B0E4110100000000000000000000000000000000000000000000000070BC0200000000004172D01D0100000000000000000000000000000000000000000000000087BC0200000000004191DA1701000000000000000000000000000000000000000000000000DD630200000000006ECA9A3B620000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
,FLD_MONEY=10000
From Inserted
Where [TBL_Char].FLD_ID=inserted.FLD_ID
and [TBL_Char].FLD_NAME=inserted.FLD_NAME
update TBL_Char set FLD_MENOW=101,FLD_X=613.6401,FLD_Y=365.9651
where FLD_MENOW='0'