显示Gungho及Mobox数据库版本的脚本

-- 20171220 以后用这个查询，以前的用 showdbver20171226 - oldziduan.txt 查询
-- 使用前 请修改 老的数据库名称 目前用的是 OIOrg.dbo OIAm.dbo OIFile.dbo OIMobox.dbo
declare @OIOrgDBVer varchar(40)
declare @AMDBVer varchar(40)
declare @OIFileDBVer varchar(40)
declare @DMSDBVer varchar(40)
declare @CODEDBVer varchar(40)
declare @GunghoVer varchar(40)
declare @REMINDDBVer varchar(40)
declare @QIDBVer varchar(40)
declare @ISSUEDBVer varchar(40)
declare @PRINTDBVer varchar(40)

select @OIOrgDBVer = 'OIOrgDB ' +(select S_C1 from OIOrg.dbo.OI_ORG_DBVER) + ' New- 20200109'
select @AMDBVer = 'AM8DB ' +(select S_C1 from OIAm.dbo.OI_STK_DBVER) + ' New- 20200327'
select @OIFileDBVer = 'OIFileDB ' +(select S_C1 from OIFile.dbo.OI_FILE_DBVER) + ' New- 20151106'
select @DMSDBVer = 'DMSDB ' +(select CN_S_DMS from OIMobox.dbo.OI_SYS_DBVER) + ' New- 20201117'

-- select @CODEDBVer = 'CODEDB ' +(select CN_S_CODE from OIMobox.dbo.OI_SYS_DBVER) + ' New- 20171110'
select @GunghoVer = 'GunghoDB ' +(select CN_S_GUNGHO from OIMobox.dbo.OI_SYS_DBVER) + ' New- 20201104'
-- select @QIDBVer = 'QIDB ' +(select CN_S_QI from OIMobox.dbo.OI_SYS_DBVER) + ' New- 20200603'
-- select @ISSUEDBVer = 'ISSUEDB ' +(select CN_S_ISSUE from OIMobox.dbo.OI_SYS_DBVER) + ' New- 20171110'
select @PRINTDBVer = 'PRINT ' +(select CN_S_PRINT from OIMobox.dbo.OI_SYS_DBVER) + ' New- 20171110'

print '列出目前所有数据库版本日期'
print @OIOrgDBVer
print @AMDBVer
print @OIFileDBVer
print @DMSDBVer
print '---------------------------------------'
print @GunghoVer
-- print @CODEDBVer
-- print @QIDBVer
-- print @ISSUEDBVer
print @PRINTDBVer