Post reply

Managed code within sql query

  • July 20, 2007 at 9:38 am

    #175420

    I there a way i can write managed code within an sql query, something like calling a dll withing sql.query.

    Thanks in advance

  • August 6, 2007 at 10:45 am

    #724911

    Forgive me if I have misunderstood your questions, but let me try to give you the answer that I think you are looking for...

    Using the CLR in Sql Server requires you to load the assembly into the database which makes the .dll available to your code.  If you are using a dll that is not specifically designed for sql server  (CLR sqlfunction or sqlprocedure)  such as a business object used in ASP.NET, you can write a wrapper CLR sqlfunction or sqlprocedure that in turn calls your DLL from inside it.  Then, after installing this assembly, you would access the function or procedure the same way you would any other.  But as far as I understand, in order to use managed code, you need to do it through one of the sql server attributes (sqlfunction, sqlprocedure).

    If it sounds like I understand your question but haven't fully answered, please respond and let me know.  I will try to give you more information.

  • August 21, 2007 at 12:47 am

    #728197

    Thanks you have answered my question.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply