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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment