Microsoft Transact-SQL Interview Questions
| Microsoft Transact-SQL Interview Questions |
|
|
I can't get a simple CREATE DATABASE statement to work, when I type it in it lights up in RED. Do I need certain components and/or references to get this stuff to work ???
|
|
|
|
Is it possible to do a SELECT that joins tables from 2 different databases, for example if Northwind database has a table Customer and Pubs database has a table Employee, how do I create a select statement that finds any duplicates ....
in MySQL you could do it like this:
select Northwind.Customer.Name
from Northwind.Customer join Pubs.Employee
on Northwind.Customer.Name = Pubs.Employee.Name
How does one do it in SQL server?
Thanks for reading!
|
|