The IN_DB_UTIL_FN_FORMAT_SCHEMA_VERSION scalar-valued function returns a formatted version of the base schema version number that can be used for lexical ordering and comparison of the version numbers.
| Parameter | Description | |
|---|---|---|
| SCHEMA_VERSION_IN | Type: | INPUT |
| Datatype: | NVARCHAR(40) | |
| Default Value: | NONE | |
| Description | Accepts the standard version number as stored in the IN_PRODUCT_MOD_HIST.PRODUCT_VERSION column. | |
| SCHEMA_VERSION_OUT | Type: | RETURN |
| Datatype: | NVARCHAR(40) | |
| Default Value: | None | |
| Description | Returns the formatted base version of the schema number which can be
used for lexical ordering and comparing with other formatted version
numbers. Example of formatted results returned for version 7.1.5.2u is 0007.0001.0005.0002 |
|
Examples
SELECT inuser.IN_FORMAT_SCHEMA_VERSION('7.1.5.2u');
DECLARE @VERSION_FMT NVARCHAR(40);
SET @VERSION_FMT = inuser.IN_FORMAT_SCHEMA_VERSION(inuser.IN_GET_INOW_VERSION());
PRINT 'Formatted Version Number '+@VERSION_FMT;