Have Geek Brain

Using TSQL to unlock a value

How can I unzip the varbinary (max) value in the stored procedure? I would like to implement or invoke the gunzip algorithm in TSQL code, preferably without including the CLR.

+2


a source to share


1 answer


Have a look at sp_OACreate http://msdn.microsoft.com/en-us/library/ms189763.aspx

sp_OAMethod http://msdn.microsoft.com/en-us/library/ms174984.aspx



You can write the value as a file using the filesystem object, then use the gunzip command line program on it and read the file using FSO.

Yes, it's not practical, but I'm not the kind of guy who thinks in terms of impossibility.

+1


a source






More articles:


All Articles