Extended Stored Procedure <-> CLR

Hi
I should write an Extended Stored Procedure for a SQL Server 2000. This
Extended Stored Procedure includes differnet function which I like to call
from applications (C++, Java) via ODBC or JDBC. I have
done that already, I mean I know how to do that.
But now I read something
about CLR and that several functions from the Extended Stored Procedure will
be not supported in coming SQL server versions.
- Is CLR available in SQL server 2000?
- Is there some example code available?
- How can I call a function written with CLR from a C++ (or Java) app via
ODBC (or JDBC)?
Thanks for the help.
Regards
HansHello Hans,

> - Is CLR available in SQL server 2000?
No, at least not SQLCLR as you talked about in the first part of the post.

> - Is there some example code available?
Plenty. Just Google on SQLCLR.

> - How can I call a function written with CLR from a C++ (or Java) app
> via ODBC (or JDBC)?
Essentially the same you call an XP. You need to catalog the assembly with
SQL Server, the catalog T-SQL objects (functions, sprocs, types, triggers,
aggregators) to the cataloged assembly. You can then call the mapped T-SQL
objects in a select or action statement, or with an exec depending on the
type of object cataloged.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/