为了使用此脚本，您将需要使用Numbers表。
CREATE FUNCTION [dbo].[URLEnpre] (@depredString VARCHAr(4000))RETURNS VARCHAr(4000)ASBEGINDECLARE @enpredString VARCHAr(4000)IF @depredString LIKE '%[^a-zA-Z0-9*-.!_]%' ESCAPE '!'BEGIN SELECt @enpredString = REPLACE( COALESCE(@enpredString, @depredString), SUBSTRINg(@depredString,num,1), '%' + SUBSTRINg(master.dbo.fn_varbintohexstr(ConVERT(VARBINARY(1),ASCIi(SUBSTRINg(@depredString,num,1)))),3,3)) FROM dbo.numbers WHERe num BETWEEN 1 AND LEN(@depredString) AND SUBSTRINg(@depredString,num,1) like '[^a-zA-Z0-9*-.!_]' ESCAPE '!'ENDELSEBEGIN SELECT @enpredString = @depredString ENDRETURN @enpredStringENDGO
该脚本在SQL Server
Central上完全可用（需要注册）
