Select Aras Innovator version with SQL - SQL Snipplr Social Repository

Revision: 54248

at December 16, 2011 20:57 by anthonyponceot

Updated Code

SELECT (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionMajor') + '.' + 
       (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionMinor') + ' ' + 
       (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionServicePack')  as Version

Revision: 54247

at December 16, 2011 20:34 by anthonyponceot

Initial Code

SELECT (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionMajor') + '.' + (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionMinor') + ' ' + (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionServicePack')  as Version

Initial URL

Initial Description

Select the version Of Aras Innovator

Initial Title

Select Aras Innovator version with SQL

Initial Tags

Initial Language

SQL

Choose a language for easy browsing: