
Windows Azure SQL Database Views, Indexes, andFederations ◾ 295
TASK 3: INSERTING DATA TO TABLES
After the tables are created, our next step is to insert data to those tables by following the
below steps:
1. In the ClassDB pane on the left-hand side of your screen, click the link [ClassDB].
[Class_Federation] and select Query on the context menu. en, select New Query
to open the New Query editor.
2. Enter the following SQL code and click the Run button on the ribbon:
--- inserting records into COURSE
INSERT INTO COURSE (CourseID, CourseName)
VALUES('ISC2301', 'VB')
INSERT INTO COURSE (CourseID, CourseName)
VALUES('ISC3311', 'Database')
INSERT INTO ...