O'Reilly logo

Visual Studio® 2010 All-in-One For Dummies® by Rick Leinecker

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 6. Using Visual Studio with SQL Server

In This Chapter

  • Installing SQL Server 2008 Express Edition

  • Configuring the Adventure Works sample database

  • Creating scripts in database projects

  • Creating stored procedures in SQL Server projects

  • Using Visual Database Tools

Most useful programs require some kind of data storage. Often, that's a database program like Microsoft SQL Server. SQL Server 2008 is the latest release of the popular database program and ships with Visual Studio 2010.

This chapter shows you how to install SQL Server 2008 and how to use Visual Studio to create and manage database objects.

Getting Acquainted with SQL Server 2008

SQL Server 2008 is the latest version of the popular Microsoft database management system. Each edition of Visual Studio includes a license for one of the editions of SQL Server 2008. Table 6-1 lists the editions of SQL Server and describes how to get the program.

Table 6-1. SQL Server Editions

SQL Server Version

When to Use It

How to Get It

Enterprise Edition

In large companies

Purchase separately; retail price $24,999

Standard Edition

In small- and medium-size businesses

Purchase separately; retail price $5,999

Workgroup Edition

In departments or branch offices

Purchase separately; retail price $3,899

Express Edition

For prototypes or local development

Free download from Microsoft Web site; included with all Visual Studio Express Editions and Visual Studio Standard Editions

Developer Edition

For prototypes or local development

Included with Professional, Tools for ...

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