SQL 2005 BASE64 Decode Query Syntax

Decode BASE64 encoded string SQL query syntax

– declare vars.
DECLARE @data VARCHAR(MAX), @XmlData XML

– set the base64 encoded varchar.
SET @data = ‘SGVsbG8gV29ybGQgIQ==’

– construct an xml var.
SET @XmlData = CAST(’<data>’ + @data + ‘</data>’ AS XML)

– base64 decode the @data.
SELECT   CONVERT(VARCHAR(MAX),
       @XmlData.VALUE(’(data)[1]‘, ‘varbinary(max)’))

Continue reading about SQL 2005 BASE64 Decode Query Syntax

In real world , web service of WCF in basichttpbinding might not be flexible enough to meet enterprise application requirements.
What programmers are looking at is a more robust way of developing web service application in WCF. CustomBinding as the name describes that it alllows users design their own web service binding.
At the point, people might [...]

Continue reading about WCF BasicHttpBinding equivalent CustomBinding