Archive for August, 2008
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)’))
WCF BasicHttpBinding equivalent CustomBinding
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, […]