Greg Snidow (1/11/2013)
opc.three
The C# code I provided does exactly that
Ah, my bad then. I'm C# illiterate (and all flavors of C for that matter). Now that you pointed that out, I can kind of see how it works. So I'm using SQL Server 2012 express (my company does not use SQL Server, I just use it for handling my data). Is it possible for me to do things like you have done above? Or do I need a paid version to be able to use CLR's and such?
No worries. I get that C# is not read as cleanly (or sometimes at all) on this site as T-SQL 😉
I would not recommend using the code I showed in a SQLCLR object. If you must something like this that deals with hyperlinks in Excel, I would look to put the code in an SSIS package Script Task or Transformation Component, or into a stand-alone C# app, and run it on an application server, i.e. not the server running SQL Server hosting the databases.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato