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

Question

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

Answer 1

Yes, it is possible. Check this:
http://msdn.microsoft.com/en-us/library/w2kae45k%28VS.80%29.aspx

Answer 2

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