--先创建自定义函数
CREATE FUNCTION dbo.StrToUrlEncode(@str VARCHAR(4000))
RETURNS VARCHAR(4000)
AS
BEGIN
DECLARE @n INT
DECLARE @tmp VARCHAR(10)
DECLARE @tmpUrl VARBINARY(10)
DECLARE @tmpStr VARCHAR(10)
DECLARE @ReStr VARCHAR(4000)
SET @n = 1
SET @ReStr = ''
WHILE @n <= LEN(@str)
BEGIN
SET @tmp = SUBSTRING(@str, @n, 1)
SET @tmpUrl = CAST(@tmp AS VARBINARY(10))
SET @tmpStr = master.dbo.fn_varbintohexstr (@tmpUrl)
IF LEN(@tmpStr)=4 SET @tmpStr = '%' + SUBSTRING(@tmpStr,3,2)
IF LEN(@tmpStr)=6 SET @tmpStr = '%' + SUBSTRING(@tmpStr,3,2) + '%' + SUBSTRING(@tmpStr,5,2)
SET @ReStr = @ReStr + @tmpStr
SET @n = @n + 1
END
RETURN UPPER(@ReStr)
END
--调用函数
SELECT dbo.StrToUrlEncode('测试')