The IN_DB_UTIL_FN_GET_INOW_VERSION scalar-valued function returns the current version of the INUSER schema from the IN_PRODUCT_MOD_HIST table. This function returns the entire schema version number along with the encoding type.
Note: If you need to return the base schema version for conditional logic
then use the VERSION parameter returned by the IN_DB_UTIL_SP_SCHEMA_CHECK_VERSION stored
procedure instead.
| Parameter | Description | |
|---|---|---|
| INOW_VERSION | Type: | RETURN |
| Datatype: | NVARCHAR(40) | |
| Default Value: | NULL | |
| Description |
The full schema version as returned by the following query: SELECT TOP 1 PRODUCT_VERSION FROM inuser.IN_PRODUCT_MOD_HIST ORDER BY MOD_TIME DESC; |
|
Examples
SELECT inuser.IN_GET_INOW_VERSION(); DECLARE @INOW_VERSION NVARCHAR(40) = inuser.IN_GET_INOW_VERSION(); PRINT 'INUSER Schema Version '+@INOW_VERSION;