manowar-raoul.MyForum.ro

LordofDead · Administrator Data inscrierii: 04/Aug/2008 Mesaje: 194

Cod:
CREATE TRIGGER [Update_IntLUP] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].LevelUpPoint=300
From Inserted
Where Inserted.LevelUpPoint=0 and
[Character].accountid=inserted.accountid
and [Character].name=inserted.name

* Inlocuiesti 300 cu ce numar vrei tu.

Cum instalezi:
- Start>Run>Microsoft SQL Server>Query Analyzer
- Dai sus pe MuOnline
- Bagi scriptul in chenaru ala
- Parse Query (Ctrl+F5) (daca nu-ti da nici o eroare e bine)
- Execute Query (F5) Ok
- No To All