Scalable Vector Graphics - HTML5 with Visual Studio 2012 - page 202

5. In the query window, select the Chapter 9 database from the dropdown list at the top

of the form as shown in Figure 9-8 . (Your database name will be different from mine.)

Figure 9-8. Selecting the Chapter 9 database

■ You also could right-click the connection in the Server Explorer and select the New Query link. This will con-
nect to the database and default to the current database.

Tip

6. In the download that is available at www.apress.com , you'll find a States.sql file in

the Chapter 9 folder. Copy and paste the contents of this file into the query window
and then execute the query by clicking the Execute icon or entering the Ctrl-Shift-E
command. This will create the State table using the following script and then
populate it with a record for each state.

CREATE TABLE State(
StateCode nchar(10) NOT NULL,
StateName nvarchar(50) NOT NULL,
Path ntext NULL,
CONSTRAINT PK_State PRIMARY KEY CLUSTERED
(
StateCode ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]