Alan.B (2/19/2014)
SQLRNNR (2/19/2014)
Great article. Very useful information.One question I think could be answered and would be very useful to those noobs to CLR.
How do you get the varbinary representation for the creation of the assembly?
I am a CLR noob too so forgive me if this is not the correct answer or what you are looking for but...
If you have already created the assembly you can open SSMS, go to <yourdb> then Programmability then Assemblies. Then you could right-click the assembly > select "Script Assembly AS" > Create To > New window...
This will give you the DDL to create the assembly; the hex string after FROM is the code you are looking for. You can then copy that code and convert it to varbinary as shown below...
Hope this helps. If not, I'm sure Solomon will point you in the right direction.
Oops I meant binary representation as shown in the examples. If you already have a CLR deployed, that is great. But if you are building from scratch, how to get that binary representation so you don't have to deploy an external dll too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events