« February 2013 | Main | April 2013 »

March 04, 2013

Query to select universe statements from MQDS database

The use statement specifies the database context to be used.



use MQDSV4
go

select
a.id,
a.varName,
c.MachineReadable,
c.UniverseSize

from dbo.var a
join dbo.var_insUniverse b
on a.ID = b.varID
join dbo.insUniverse c
on b.insUniverseID = c.insUniverseID

Posted by kkwaiser at 01:27 PM | Comments (0)