Posted By

anthonyponceot on 12/16/11


Tagged

Aras


Versions (?)

Select Aras Innovator version with SQL


 / Published in: SQL
 

Select the version Of Aras Innovator

  1. SELECT (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionMajor') + '.' +
  2. (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionMinor') + ' ' +
  3. (SELECT [VALUE] FROM [innovator].[VARIABLE] WHERE NAME LIKE 'VersionServicePack') AS Version

Report this snippet  

You need to login to post a comment.