Numarul mesajelor : 47 Varsta : 31 Localizare : Timisoara Data de inscriere : 26/09/2009
Subiect: Bonus Caracter Mier Dec 09, 2009 2:33 pm
Cum bagi puncte la un caracter now de la 0 !!!
Rulezi codu in QA
Cod:
CREATE TRIGGER [Update_IntLUP] ON [dbo].[Character] after Insert as Update [Character] set [Character].LevelUpPoint=2500 From Inserted Where Inserted.LevelUpPoint=0 and [Character].accountid=inserted.accountid and [Character].name=inserted.name