I've a function written in c that takes about thousands lines of code. I have to implement the same function as a scalar valued function on SQL Server. Is there a way to generate a SQL server function from .c code? In Visual Studio, there is a project called "Database Project" that allow to do this from c# or vb code but I don't find the equivalent project from c/c++...
Here http://msdn.microsoft.com/en-us/library/ms131043.aspx, they say : Managed Visual C++ database objects that have been compiled with the /clr:pure Visual C++ compiler option are not supported for execution on SQL Server 2005. For example, such database objects include scalar-valued functions.
I suppose it's the same for C functions, isn't ?
Maybe I could call a C-compiled function of a .dll from c# code via the interoperability (DllImport) ?
A function from the CA-clipper language that I have to implement on the server side. It takes two parameters. An expression and a formatting string and return a formatted expression. The formatting string possibilities can be infinity : it's a composition of several action to apply either on a character or on the whole string.
What about this sentence : Managed Visual C++ database objects that have been compiled with the /clr:pure Visual C++ compiler option are not supported for execution on SQL Server 2005. For example, such database objects include scalar-valued functions.
It's not possible to reuse the c code via the clr ?
generate a function from c code.
Posted - 07/16/2008 : 21:51:03
