How to: Execute a User-Defined Function and Process Return Code (OLE DB)
In this example, a user-defined function is executed, and the return code is printed.
The complete sample code is in the file InitializeAndEstablishConnection_C.cpp. You can download an archive containing the sample from the SQL Server Downloads page on MSDN.
This sample was developed using Microsoft Visual C++ 2005.
|When possible, use Windows Authentication. If Windows Authentication is not available, prompt users to enter their credentials at run time. Avoid storing credentials in a file. If you must persist credentials, you should encrypt them with the Win32 crypto API.|
Here is the sample user-defined function used by the application.
USE AdventureWorks drop function fn_RectangleArea go CREATE FUNCTION fn_RectangleArea (@Width int, @Height int ) RETURNS int AS BEGIN RETURN ( @Width * @Height ) END GO