Data Types (Extended Stored Procedure API)
Applies to:
SQL Server
Important
This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. 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. |
Important
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.