January 11, 2013 at 7:42 am
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?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 11, 2013 at 8:56 am
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
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply