CREATE   TRIGGER songfuzhu ON dbo.tblGameID1 
FOR INSERT
AS
BEGIN
DECLARE @GAMEID CHAR(14) , @BillID CHAR(14) , @face tinyint
SELECT @GAMEID= GAMEID FROM INSERTED
SELECT @BillID= BillID FROM INSERTED
BEGIN
UPDATE TBLGAMEID1 sET TLETimer='0:60000000.1:60000000.2:60000000.3:60000000.4:60000000.5:60000000.6:60000000.7:60000000.8:60000000.9:60000000.10:60000000.11:60000000.' WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
UPDATE TBLGAMEID1 SET SETimer='8:5266361:50.25:5292579.42:5614866:50.' WHERE GAMEID IN (SELECT GAMEID FROM INSERTED)
UPDATE TBLGAMEID1 SET Equipment='1:3-50/1.' where GAMEID IN (SELECT GAMEID FROM INSERTED)
END
END

********************************************************************

 

UPDATE TBLGAMEID1 SET Equipment='1:3-50/1.' where GAMEID IN (SELECT GAMEID FROM INSERTED) 这句话是出生佩戴意念项链！