Data Types (Extended Stored Procedure API)

Important

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. 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.

Security Note
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.