O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 15. Working with Heterogeneous Environments: Setting Up Linked Servers

Chapter 14, "Transferring Data to and from SQL Server," introduced the idea of transferring data between different databases, servers, or platforms. In this chapter, you will practice with SQL Server 2000 features that enable you to execute queries that span multiple servers.

In some cases, you might want to access data that is not stored in SQL Server, that perhaps is not even relational. As long as you have an ODBC driver or an OLE DB provider to connect to this particular data, you can use linked servers, or rowset functions, to access this data from any Transact-SQL batch, stored procedure, trigger, or user-defined function.

This chapter teaches you the following: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required