Поделиться через


How to: Execute a User-Defined Function and Process Return Code (OLE DB)

Добавления: 14 апреля 2006 г.

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.

ms403328.security(ru-ru,SQL.90).gifПримечание безопасности.
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

См. также

Основные понятия

Processing Results (OLE DB)

Справка и поддержка

Получение помощи по SQL Server 2005