 |
|
|
| Autor |
Mesaj |
NaRuTo'
Special Jounin
Data inscrierii: 18/Feb/2008
Mesaje: 124
Localitate: Bucuresti
|
 Trimis: 18/02/2008 01:44 Titlul subiectului: Asa pui 32000 la command la DL de lvl 0 |
 |
|
1. Pentru Query Analizer 
Bagi codul asta in QA (Query Analizer)
Merge 100% testat de mine
Atentie! Doar characterele lucrate dupa ce ai rulat scriptul vor avea 32000 la command.
| Cod: | -- =============================================
-- Create Command for Dark Lord
-- (C) 2007 by NaRuTo
-- 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: | -- =============================================
-- Create Command for Dark Lord
-- (C) 2007 by NaRuTo
-- Microsoft SQL Job
-- =============================================
UPDATE Character
SET Leadership= ('32000')
WHERE CtlCode<64 |
[/url][/list]
_________________
By NaRuTo     |
|
| Sus |
|
 |
|
|
Nu puteti crea un subiect nou in acest forum
Nu puteti raspunde in subiectele acestui forum
Nu puteti modifica mesajele proprii din acest forum
Nu puteti sterge mesajele proprii din acest forum
Nu puteti vota in chestionarele din acest forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
|
