« 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)