通过

Data Types (Extended Stored Procedure API)

ms164638.note(zh-cn,SQL.90).gif重要提示：
后续版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。 Use CLR integration instead.

To use the Extended Stored Procedure API data types, include the Srv.h header file in your program.

Data type SQL Server data type Description

SRVBIGBINARY

binary

binary data type, length 0 to 8000 bytes.

SRVBIGCHAR

char

character data type, length 0 to 8000 bytes.

SRVBIGVARBINARY

varbinary

Variable-length binary data type, length 0 to 8000 bytes.

SRVBIGVARCHAR

varchar

Variable-length character data type, length 0 to 8000 bytes.

SRVBINARY

binary

binary data type.

SRVBIT

Bit

bit data type.

SRVBITN

bit null

bit data type, null values allowed.

SRVCHAR

char

character data type.

SRVDATETIME

datetime

8-byte datetime data type.

SRVDATETIM4

smalldatetime

4-byte smalldatetime data type.

SRVDATETIMN

datetime null

smalldatetime or datetime data type, null values allowed.

SRVDECIMAL

decimal

decimal data type.

SRVDECIMALN

decimal null

decimal data type, null values allowed.

SRVFLT4

real

4-byte real data type.

SRVFLT8

float

8-byte float data type.

SRVFLTN

real | float null

real or float data type, null values allowed.

SRVIMAGE

image

image data type.

SRVINT1

tinyint

1-byte tinyint data type.

SRVINT2

smallint

2-byte smallint data type.

SRVINT4

int

4-byte int data type.

SRVINTN

tinyint | smallint | int null

tinyint, smallint, or int data type, null values allowed.

SRVMONEY4

smallmoney

4-byte smallmoney data type.

SRVMONEY

money

8-byte money data type.

SRVMONEYN

money | smallmoney null

smallmoney or money data type, null values allowed.

SRVNCHAR

nchar

Unicode character data type.

SRVNTEXT

ntext

Unicode text data type.

SRVNUMERIC

numeric

numeric data type.

SRVNUMERICN

numeric null

numeric data type, null values allowed.

SRVNVARCHAR

nvarchar

Unicode variable-length character data type.

SRVTEXT

text

text data type.

SRVVARBINARY

varbinary

Variable-length binary data type.

SRVVARCHAR

varchar

Variable-length character data type.
ms164638.security(zh-cn,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.