Does anyone know how you could create a view in one db of a table in another db on the same sql server? or how to perform a cross db join in a query?
thanks!Eg;
create view temp as
select a.* from
master..syslogins a, msdb..sysjobs
Use the books online feature that comes with SQL server. Most useful!
Meera
Showing posts with label cross. Show all posts
Showing posts with label cross. Show all posts
Subscribe to:
Posts (Atom)