knight
Fondator
Mesaje : 192
Data de înscriere : 27/03/2008
Varsta : 30
Localizare : Undeva...Nush pe unde...Dar pe undeva :D
 |  Subiect: Cum pui 32000 command la Dark Lord de la level 0  Vin Mar 28, 2008 5:56 pm | |
| 1. Pentru Query Analizer ! * Bagi codul asta in QA (Query Analizer) * Merge 100% testat de mine * Atentie! Doar characterele create dupa ce ai rulat scriptul vor avea 32000 la command.Cod: - Cod:
-
-- =============================================
-- Create Command for Dark Lord
-- (C) 2008 FunnyZone
-- Query Analizer
-- =============================================
CREATE TRIGGER [Update_Command] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=32000
From Inserted
Where Inserted.Leadership=25 and
[Character].accountid=inserted.accountid
and [Character].name=inserted.name 2. Pentru SQL Server Agent (SQL Job)Cod: - Cod:
-
-- =============================================
-- Create Command for Dark Lord
-- (C) 2007 by Disconnect
-- Microsoft SQL Job
-- =============================================
UPDATE Character
SET Leadership= ('32000')
WHERE CtlCode<64 | |
|
