Advanced Search

Select Aras Innovator version with SQL

/ Published in: SQL
Save to your folder(s)
Select the version Of Aras Innovator

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

You need to login to view comments.