SQL Server Linked Servers

preview_player
Показать описание
Rich Bendickson of Dashboard Gear discusses how to set up Linked Servers and how to use them in a SQL Server query.
Рекомендации по теме
Комментарии
Автор

This was exactly what I was looking for.
The "SQL Server" servertype was not working and you were the only one explained using the "Other data source".
Thank you.

rraaffaaeell
Автор

You just saved me. I spent 4 hours for this.

laughing
Автор

In the interest of full disclosure, you should start off with a statement that at 8:56 you are going to say, "'if you are querying a spreadsheet, you've got to issue a command that a spreadsheet can understand' but I'm not going to tell you, although if you are querying Oracle I'll give you setup tips for that."

lindaitken
Автор

Have you done a video on downloading and installing the right "bit" client versions? e.g. 64 bit drivers? This extends I think to being able to use the Import/Export Wizard to, for example, load files via SSMS into a SQL Server table?

DM-pypj