Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Tutorials · Integration Services Training
   
Transact-SQL Programming and Query Writing Training Videos
Transact SQL Videos By Chapter Home  Subscriber Videos  

Chapter: Dynamic Data Source Queries - How to Write Distributed Data Queries Using Linked Servers and more Tutorials - (all chapters)

Video Image Did you know that you can write a Transact-SQL SELECT statement against an Oracle instance or even an Excel spreadsheet? You certainly can and many more data sources are also available. This category focuses on external data queries and features some pretty interesting ideas.

Versions/Editions Covered: SQL Server 2000
Videos in this Chapter: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Creating Linked Servers to Microsoft Access (SQL Server 2000)   400 Download 13 mins.
Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL S...   400 Download 11 mins.
Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)   300 Download 17 mins.
Miscellaneous Bits & Pieces:
nslookup is a great command-line tool to diagnose DNS issues
Helpful Keyboard Shortcuts: "CTRL" + "ALT" + "DELETE" displays the Windows Security dialog box and/or allows the user to logon
Want to see something cool? Run SELECT cacheobjtype, objtype, pagesused, sql FROM master.dbo.syscacheobjects ORDER BY pagesused DESC

   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/7/2009 3:54:20 AM