IN_DB_UTIL_FN_FORMAT_SCHEMA_VERSION - Perceptive Content Database IN_DB_UTIL Package 5.0 for SQL Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Perceptive Content Database IN_DB_UTIL Package 5.0 for SQL Server

Platform
Perceptive Content
Product
Perceptive Content Database IN_DB_UTIL Package 5.0 for SQL Server
Release
Foundation 24.1
License

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;