-
Shop Dark Team
Alguem sabe porq na hora que eu vou roda essa query da esse erro
CREATE TRIGGER Cash_bonus ON dbo.[DT_Shop_Credits] FOR INSERT
AS
BEGIN
--Bonus Para Novas accs no shop--
DECLARE
@Creditos INT,
@Acc Varchar(10)
SELECT @Acc = login FROM INSERTED
set @Creditos = 10 -- Quantidade de creditos
Update Dbo.DT_SHOP_Credits
SET Credits = @Creditos
Where login = @Acc
End
da esse erro
Server: Msg 2714, Level 16, State 5, Procedure Cash_bonus, Line 14
There is already an object named 'Cash_bonus' in the database.
-
É pq a trigger já existe.
Rode isto antes:
USE MuOnline
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'Cash_bonus' AND type = 'TR')
DROP TRIGGER Cash_bonus
GO
-
rodei e pego sim vlws ai '-'