T-SQL Query
Could someone help me with a T-SQL syntax that could pull records from two different databses but same server?
Thanks
January 13th, 2011 5:23pm
you can use this signature [DatabaseName].[SchemaName].[ObjectName] in the t-sql.
for example:
select * from [FirstDB].[dbo].[table1]
inner join [SecondDB].[dbo].[table2]
on [FirstDB].[dbo].[table1].Field1=[SecondDB].[dbo].[table2].Field1http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
January 13th, 2011 5:32pm
Thank you very much. I will try it.
January 13th, 2011 5:52pm