PDA

View Full Version : |Jobs/Query| Query zen no baú



antoniodel
24/01/2016, 11:32 AM
[Only registered and activated users can see links]
Boa sorte e bom uso.

Season 4 x-Team

USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO


CREATE TRIGGER MUC_BONUS ON dbo.MEMB_INFO FOR INSERT
AS
BEGIN




DECLARE
@Dinheiro INT,
@login varchar(10)
[Only registered and activated users can see links]


[Only registered and activated users can see links]


INSERT INTO dbo.warehouse (AccountID, Money,
pw, EndUseDate)
[Only registered and activated users can see links]
END

Season 8 x-Team


USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO


CREATE TRIGGER MUC_BONUS ON dbo.MEMB_INFO FOR INSERT
AS
BEGIN




DECLARE
@Dinheiro INT,
@login varchar(10),
@Item varbinary(3840)
[Only registered and activated users can see links]


[Only registered and activated users can see links]
[Only registered and activated users can see links]


INSERT INTO dbo.warehouse (AccountID, Money,
pw, EndUseDate, Items)
[Only registered and activated users can see links]
END


Para remover essa query, basta rodar essa aqui.


USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'MUC_BONUS' AND type = 'TR')
DROP TRIGGER MUC_BONUS
GO

Créditos: iFreeHP