다음을 통해 공유


Usage Scenarios and Examples for Common Language Runtime (CLR) Integration

Microsoft SQL Server 2005 includes sample applications, package samples, and numerous coding samples that you can use to learn about the programmability features of common language runtime (CLR) integration.

The following table describes the CLR integration programmability samples.

Name Description

AdventureWorks 주기 CLR 레이어

Provides utilities that form an extra layer of functionality on top of the base AdventureWorks sample database.

보충 문자 인식 문자열 조작

Shows the implementation of five supplementary-aware Transact-SQL string functions that can handle both Unicode and surrogate strings.

LOB(Large Object) 처리

Demonstrates transferring large binary objects (LOBs) between SQL Server and a file system accessible to the server using CLR stored procedures.

In-Process 데이터 액세스 예제

Contains a number of simple functions demonstrating various features of the CLR in-process data access provider.

문자열 유틸리티 예제

Contains a streaming table-valued function (TVF), written in Microsoft Visual C# and Microsoft Visual Basic, which splits a comma-separated string into a table with one column.

UDT 유틸리티

Contains a number of user-defined data type (UDT) utility functions.

사용자 정의 데이터 형식(UDT) 예제

Shows the creation and use of a simple UDT from both Transact-SQL and a client application using System.Data.SqlClient.

UTF8 문자열 사용자 정의 데이터 형식(UDT)

Demonstrates the implementation of a UDT that extends the type system of the database to provide storage for UTF8 encoded values.

달력 인식 날짜/시간 UDT

Defines two UDTs that provide calendar-aware handling of dates and times.

결과 집합 예제

Demonstrates how to execute commands while reading through results of a query, without opening a new connection and without reading all results into memory.

배열 매개 변수 예제

Demonstrates how to create, update, or delete a set of rows in a database by passing an array of information from a client to a CLR integration stored procedure on the server. This is done using a UDT.

Hello World 예제

Demonstrates the basic operations to create, deploy, and test a simple CLR integration-based stored procedure.

Hello World Ready 예제

Demonstrates the basic operations to create, deploy, and test a simple world ready CLR integration-based stored procedure.

가장 예제

Demonstrates how to use impersonation to use the credentials passed from the client. This is done to access operating system protected resources when you are using integrated security.

공간 예제

Demonstrates how to use impersonation to use the credentials passed from the client to access operating system protected resources, such as files, when you are using integrated security.

Oracle TVF 예제

Demonstrates how to invoke the managed code interface to Oracle to expose the results of any Oracle query as a table-valued function.

데이터 집합 보내기 예제

Demonstrates how to return an ADO .NET based DataSet within a server side CLR-based stored procedure as a result set to the client.

System.Transactions 예제

Demonstrates controlling transactions by using the managed APIs located in the System.Transactions namespace.

참고 항목

관련 자료

SQL Server 데이터베이스 엔진 예제

도움말 및 정보

SQL Server 2005 지원 받기