Is it possible to call a function from and dotnet assemble from a MS SQL query?

Is it possible to call a functi开发者_JS百科on from and dotnet assemble from a MS SQL query?

---

You can do this by creating a CLR Stored procedure as long as you are using SQL Server 2005 or 2008.

You can also create CLR triggers, UDFs and few others.

http://en.wikipedia.org/wiki/SQL_CLR