Re: Simplest CLR

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



If anyone tells you to use Visual Studio, run away screaming. It's not
free, and it's absolutely not simple.

While visions of C:\ prompts danced in his head... :) Don't scare the man
Erland, or Santa Claus will put a lump of carbon credits in your stocking :)

"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9CDA934A0C9DEYazorman@xxxxxxxxxxxx
Jay (spam@xxxxxxxxxx) writes:
What is the simplest (and cheapest/free) way I can use CLR on my home
machine?

Have a look at
http://www.sommarskog.se/arrays-in-sql-2005.html#CLR, there
is some example how to compile and load, using stuff that is on your
machine already, provided that you have SQL Server there. (If you haven't,
you can download and install .Net Framework.)

You can also look at http://www.sommarskog.se/dyn-search-2005.html#CLR.
The article only shows C# code, but there is example in VB .Net in one
of the files.

If anyone tells you to use Visual Studio, run away screaming. It's not
free, and it's absolutely not simple.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.



Relevant Pages

  • Re: getdate() in UDF
    ... Or it is classified as imprecise rather than non-deterministic? ... return from Erland) ... > Here noofyears is a computed column which tells us how long a person ... > SQL Server must materialize the values. ...
    (microsoft.public.sqlserver.programming)
  • Re: Prepared statement doing table scan
    ... Thanks Erland! ... The idea was to use a plan guide to force use of the index. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.server)
  • Re: more than 8192 characters in text file output
    ... Thanks Erland. ... results that are "export as grid" you can't choose the delimiter. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • Re: stored procedure question
    ... Erland, ... regarding computing and large insert be done directly in the database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Syntax coloring: SERVICE
    ... If so, Erland, it is only because I have failed in my attempts to ... any version of Outlook. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)