How to call c# or Javascript function in SQl Server
Hello Sir/MadamCan you please suggest , is there any way to call a javascript or C# function call in Sql Server .
Thanks,
Bhavik Shah
You must Sign In to post a response.
Category: .NET
Can you please suggest , is there any way to call a javascript or C# function call in Sql Server .
Thanks,
Bhavik Shah
#766096
Hi,
You can call C# functions from SQL Server Stored Procedure with the help of CLR(Common Language Runtime) SP.
Please refer this URL:
http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/
You can call C# functions from SQL Server Stored Procedure with the help of CLR(Common Language Runtime) SP.
Please refer this URL:
http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/
#766115
SQL Server 2005 supports CLR so it means we can use CLR in backend so how to do that. let's see.
Yes, it is possible to use .NET in a SQL Server 2005 database. and .Net framework 2.0 and above.
MSDN says,
Create a SQL user-defined function by adding a User-Defined Function to a SQL Server project. After successful deployment, the user-defined function can be called and executed.
see below links
http://stackoverflow.com/questions/4002382/how-to-call-c-sharp-function-in-stored-procedure
https://msdn.microsoft.com/en-us/library/w2kae45k(v=vs.90).aspx
http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]
Yes, it is possible to use .NET in a SQL Server 2005 database. and .Net framework 2.0 and above.
MSDN says,
Create a SQL user-defined function by adding a User-Defined Function to a SQL Server project. After successful deployment, the user-defined function can be called and executed.
see below links
http://stackoverflow.com/questions/4002382/how-to-call-c-sharp-function-in-stored-procedure
https://msdn.microsoft.com/en-us/library/w2kae45k(v=vs.90).aspx
http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]
#766140
1. For do this you have to create "SQL Server Project"
2. You have to use [Microsoft.SqlServer.Server.SqlProcedure] for methods.
3. You can run the C# project directly in the your query analyser.
EXEC <SQL Project>
By Nathan
Direction is important than speed
2. You have to use [Microsoft.SqlServer.Server.SqlProcedure] for methods.
3. You can run the C# project directly in the your query analyser.
EXEC <SQL Project>
By Nathan
Direction is important than speed
Return to Return to Discussion Forum