Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to call C# function in stored procedure

SQL Server 2005 supports CLR so it means we can use CLR in backend so how to do that, I have some function in c# which do some complex manipulation with date-time variable now I want to use those functions in SP. First of all IS IT POSSIBLE TO DO THIS.

like image 857
Jeevan Bhatt Avatar asked Oct 23 '10 03:10

Jeevan Bhatt


1 Answers

Yes, it is possible to use .NET in a SQL Server 2005 database. Be aware that the .NET version supported by SQL Server 2005 is 2.0.

Here's a link for an introduction to Making a CLR stored procedure using Visual Studio

like image 141
OMG Ponies Avatar answered Oct 01 '22 03:10

OMG Ponies