-- ================================================
-- eMedya (TÜFEKÇİLER ).SQL
-- T-SQL:
-- eMedya (Edip Tüfekçiler).SQL
-- ================================================
ALTER FUNCTION [dbo].[MetaTemizle]
(
@GelenVeri nvarchar(255)
)
RETURNS nvarchar(255)
AS
BEGIN
DECLARE @Sonuc nvarchar(255)
SELECT @Sonuc=@GelenVeri
SET @Sonuc=replace(@Sonuc,'A','a')
SET @Sonuc=replace(@Sonuc,'B','b')
SET @Sonuc=replace(@Sonuc,'C','c')
SET @Sonuc=replace(@Sonuc,'Ç','c')
SET @Sonuc=replace(@Sonuc,'D','d')
SET @Sonuc=replace(@Sonuc,'E','e')
SET @Sonuc=replace(@Sonuc,'F','f')
SET @Sonuc=replace(@Sonuc,'G','g')
SET @Sonuc=replace(@Sonuc,'Ğ','g')
SET @Sonuc=replace(@Sonuc,'H','h')
SET @Sonuc=replace(@Sonuc,'I','i')
SET @Sonuc=replace(@Sonuc,'İ','i')
SET @Sonuc=replace(@Sonuc,'J','j')
SET @Sonuc=replace(@Sonuc,'K','k')
SET @Sonuc=replace(@Sonuc,'L','l')
SET @Sonuc=replace(@Sonuc,'M','m')
SET @Sonuc=replace(@Sonuc,'N','n')
SET @Sonuc=replace(@Sonuc,'O','o')
SET @Sonuc=replace(@Sonuc,'Ö','o')
SET @Sonuc=replace(@Sonuc,'P','p')
SET @Sonuc=replace(@Sonuc,'R','r')
SET @Sonuc=replace(@Sonuc,'Ş','s')
SET @Sonuc=replace(@Sonuc,'S','s')
SET @Sonuc=replace(@Sonuc,'T','t')
SET @Sonuc=replace(@Sonuc,'U','u')
SET @Sonuc=replace(@Sonuc,'Ü','u')
SET @Sonuc=replace(@Sonuc,'V','v')
SET @Sonuc=replace(@Sonuc,'Y','y')
SET @Sonuc=replace(@Sonuc,'Z','z')
SET @Sonuc=replace(@Sonuc,'W','w')
SET @Sonuc=replace(@Sonuc,'Q','q')
SET @Sonuc=replace(@Sonuc,'¨','-')
SET @Sonuc=replace(@Sonuc,' ','-')
SET @Sonuc=replace(@Sonuc,'_','-')
SET @Sonuc=replace(@Sonuc,'?','-')
SET @Sonuc=replace(@Sonuc,'\','-')
SET @Sonuc=replace(@Sonuc,'*','-')
SET @Sonuc=replace(@Sonuc,'=','-')
SET @Sonuc=replace(@Sonuc,'}','-')
SET @Sonuc=replace(@Sonuc,')','-')
SET @Sonuc=replace(@Sonuc,']','-')
SET @Sonuc=replace(@Sonuc,'(','-')
SET @Sonuc=replace(@Sonuc,'[','-')
SET @Sonuc=replace(@Sonuc,'/','-')
SET @Sonuc=replace(@Sonuc,'{','-')
SET @Sonuc=replace(@Sonuc,'&','-')
SET @Sonuc=replace(@Sonuc,'%','-')
SET @Sonuc=replace(@Sonuc,'+','-')
SET @Sonuc=replace(@Sonuc,'$','-')
SET @Sonuc=replace(@Sonuc,'^','-')
SET @Sonuc=replace(@Sonuc,'^^','-')
SET @Sonuc=replace(@Sonuc,'#','-')
SET @Sonuc=replace(@Sonuc,'','-')
SET @Sonuc=replace(@Sonuc,'!','-')
SET @Sonuc=replace(@Sonuc,'"','-')
SET @Sonuc=replace(@Sonuc,'é','-')
SET @Sonuc=replace(@Sonuc,'<','-')
SET @Sonuc=replace(@Sonuc,'>','-')
SET @Sonuc=replace(@Sonuc,'"','-')
SET @Sonuc=replace(@Sonuc,'~','-')
SET @Sonuc=replace(@Sonuc,',','-')
SET @Sonuc=replace(@Sonuc,';','-')
SET @Sonuc=replace(@Sonuc,'``','-')
SET @Sonuc=replace(@Sonuc,':','-')
SET @Sonuc=replace(@Sonuc,'.','-')
SET @Sonuc=replace(@Sonuc,'','-')
SET @Sonuc=REPLACE(@Sonuc,' ',',')
SET @Sonuc=REPLACE(@Sonuc,' ',',')
RETURN @Sonuc
END
CREATE PROCEDURE DENEME
(
@DENEME NVARCHAR(255)
)
INSERT INTO DENEME
(
DENEME
)
VALUES
(
dbo.MetaTemizle(@DENEME)
)