November 2005
Intermediate to advanced
236 pages
6h 32m
English
Content preview from Integrating Excel and AccessBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
SQL Server Summary
This chapter went into some intermediate-level topics on SQL Server that you may not already be familiar with. I could write several chapters on the topics covered, but I just wanted to introduce them in this chapter. If you type in the examples as shown, you can see how they work. I find that by following examples and tweaking code, I learn a lot about how things work. I encourage you to follow these examples, and I strongly suggest that you test everything in Pubs or Northwind before trying it on a production database if you are not completely familiar with SQL Server.
If you are already familiar with SQL Server, I hope that the topics on DTS introduced you to some additional functionality. When I work with clients using SQL Server, I find that very few take advantage of the ActiveX script tasks, Email tasks, and scheduling functionality, except in the case of administrative tasks. There are so many ways to use the scheduling tool that I even use it when it doesn't involve SQL Server. You can create connections to Access databases with DTS and drop and create tables on a daily basis for different types of reporting, even if none of the data is on SQL Server. In addition, you can find a lot of good examples in the SQL Server Books Online if you get stumped trying to figure something out.
It is going to be increasingly difficult to ignore SQL Server and other enterprise databases as these databases are used at more companies. Even though it is unlikely that you ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.