Yapmanız gereken aşağıdaki triggerı veri tabanına yerleştirmek...
Belki buradan bu triggerı geliştirebiliriz...
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Yazan: dnnTurkiye,,Melih Eroglu> -- Tarih: 27 Mart 2006, -- Açıklama: Bu trigger Signature alanındaki potansiyel tehditleri temizler, -- ============================================= Create TRIGGER [dbo].[KodTemizle] ON [dbo].[Forum_Users] AFTER UPDATE AS DECLARE @Signature nvarchar(1024) DECLARE @Userid varchar(50) SELECT @Userid=Userid FROM inserted SELECT @Signature=Signature FROM inserted SELECT @Signature=REPLACE(@Signature,'s t y l e','s t y l e') SELECT @Signature=REPLACE(@Signature,'m e t a','m e t a') SELECT @Signature=REPLACE(@Signature,'r e f r e s h','r e f r e s h') SELECT @Signature=REPLACE(@Signature,'click','n o c l i c k') SELECT @Signature=REPLACE(@Signature,'mouse','m o u s e')
BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
update [dbo].[Forum_Users] SET Signature=REPLACE(@Signature,'s c r i p t','s c r i p t') where Userid=@Userid
END