srv_setcollen (Extended Stored Procedure API)

중요:
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오. Use CLR integration instead.

Specifies the current data length in bytes of a variable-length column or a column that allows NULL values.

구문

int srv_setcollen (
SRV_PROC *
srvproc
,
int 
column
,
int
len 
);

Arguments

• srvproc
  Is a pointer to the SRV_PROC structure that is the handle for a particular client connection. The structure contains information the Extended Stored Procedure API library uses to manage communication and data between the application and the client.

• column
  Indicates the number of the column for which the data length is being specified. Columns are numbered beginning with 1.

• len
  Indicates the length, in bytes, of the column data. A length of 0 means the column data value is null.

Returns

SUCCEED or FAIL.

주의

Each column of the row must first be defined with srv_describe. The column data length is set by the last call to srv_describe or srv_setcollen. If variable-length data (null-terminated data) changes for a row, srv_setcollen must be used to set it to the new length before calling srv_sendrow. For a column that allows null values, srv_describe must have been called with desttype set to a data type that allows nulls (like SRVINTN) and null data is specified by calling srv_setcollen with len set to 0. Zero length data cannot be specified using the Extended Stored Procedure API.

Note that when the data type of the column is variable-length, len is not checked. This function returns FAIL if called for a fixed-length column.

보안 정보:
You should thoroughly review the source code of extended stored procedures, and you should test the compiled DLLs before you install them on a production server. For information about security review and testing, see this Microsoft Web site.

참고 항목

참조

srv_describe (Extended Stored Procedure API)

도움말 및 정보

SQL Server 2005 지원 받기