Home
Member since Nov 13, 2007, follows 0 people, 0 public groups, 458 public bookmarks (485 total).
More »
Tags
| Recent Tags: |
|
|---|---|
| Top Tags: |
|
More »
Recent Bookmarks and Annotations
-
Peter DeBetta's SQL Programming Blog : T-SQL UrlDecode on 2007-11-14
-
CREATE FUNCTION dbo.UrlDecode(@url varchar(3072))
RETURNS varchar(3072)
AS
BEGIN
DECLARE @count int, @c char(1), @cenc char(2), @i int, @urlReturn varchar(3072)
SET @count = Len(@url)
SET @i = 1
SET @urlReturn = ''
WHILE (@i <= @count)
BEGIN
SET @c = substring(@url, @i, 1)
IF @c LIKE '[!%]' ESCAPE '!'
BEGIN
SET @cenc = substring(@url, @i + 1, 2)
SET @c = CHAR(CASE WHEN SUBSTRING(@cenc, 1, 1) LIKE '[0-9]'
THEN CAST(SUBSTRING(@cenc, 1, 1) as int)
ELSE CAST(ASCII(UPPER(SUBSTRING(@cenc, 1, 1)))-55 as int)
END * 16 +
CASE WHEN SUBSTRING(@cenc, 2, 1) LIKE '[0-9]'
THEN CAST(SUBSTRING(@cenc, 2, 1) as int)
ELSE CAST(ASCII(UPPER(SUBSTRING(@cenc, 2, 1)))-55 as int)
END)
SET @urlReturn = @urlReturn + @c
SET @i = @i + 2
END
ELSE
BEGIN
SET @urlReturn = @urlReturn + @c
END
SET @i = @i +1
END
RETURN @urlReturn
END
GO
-
- Hack Attack: Build a Hackintosh Mac for Under $800 on 2007-11-13
- StringTemplate Template Engine on 2007-11-13
- NVelocity - NVelocity on 2007-11-13
- Top 10 Killer Apps For Linux « Everything Else on 2007-11-13
- Partitioning Windows and Ubuntu on 2007-11-13
- YumUpgradeFaq - Fedora Project Wiki on 2007-11-13
- Ubuntu Essentials, 2006 edition on 2007-11-13
- Upgrading Red Hat Linux/Fedora Core with yum on 2007-11-13
- Richard's Digital Rag Daily - Update Fedora Core 4 to FC5 in place on 2007-11-13
Recent Visitors (67 visits)
-
on 2009-07-05
-
on 2008-12-01
Diigo is about better ways to research, share and collaborate on information. Learn more »
Join Diigo