March 2007 - Posts

• T-SQL Convert Hex String to Varbinary

  [EDIT] I made a few changes to account for the issues Chris and Cooter noted in the comments. One last post before I go on vacation next week... SQL Server 2005 includes an undocumented function, sys.fn_varbintohexstr, that converts a hex value to a string Read More... Posted Friday, March 09, 2007 3:38 PM by Peter DeBetta | 14 Comments Filed under: T-SQL

• T-SQL UrlDecode

  While I'm at it, here is the counterpart to the UrlEncode function – UrlDecode: 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 Read More... Posted Friday, March 09, 2007 3:12 PM by Peter DeBetta | 7 Comments Filed under: T-SQL

• T-SQL UrlEncode

  I was perusing the newsgroups when I came across a request in the microsoft.public.sqlserver.clr newsgroup to see if there was a way to use System.Web.HttpUtility.UrlEncode in T-SQL. I know using the CLR is an option, but I decided to write a T-SQL equivalent. Read More... Posted Friday, March 09, 2007 12:08 PM by Peter DeBetta | 12 Comments Filed under: T-SQL

• DevWeek Downloads

  For all those who attended any of my talks at DevWeek In London last week, I have included any changed slide decks and code samples in the attached zip file (at bottom of post). Enjoy! Share this post: email it! | bookmark it! | digg it! | reddit! | kick Read More... Posted Friday, March 09, 2007 11:45 AM by Peter DeBetta | 3 Comments Filed under: Conference, Code Attachment(s): DevWeek-PeterDeBetta.zip