srv_setutype (Extended Stored Procedure API)
.gif "ms164679.note(zh-tw,SQL.90).gif") 重要事項： |
|---|
| 未來的 Microsoft SQL Server 發行版本將不再提供此功能。請勿在新的開發工作中使用此功能，並且儘速修改使用此功能的應用程式。 Use CLR integration instead. |
Sets the user-defined data type for a column in a row.
語法
int srv_setutype (
SRV_PROC *
srvproc
,
int
column
,
DBINT
user_type
);
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 which column to set. Columns are numbered beginning with 1.
- user_type
Specifies the user-defined data type code.
Returns
SUCCEED or FAIL. Returns FAIL if the column does not exist.
備註
A column has two data types: its actual data type and its user-defined data type. The user-defined data type is used by Microsoft SQL Server to store the actual user-defined data type of the column, if any, and column description information, such as nullability and updatability, for the column.
The srv_setutype function can be called any time that column has been defined with srv_describe and before the last row has been sent.
.gif "ms164679.security(zh-tw,SQL.90).gif") 安全性注意事項： |
|---|
| 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)