« Word of the day: Codeframe | Main | Visual Studio and blankpages »

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 March 4, 2013 01:27 PM

Comments

Login to leave a comment. Create a new account.