Databases Reference
In-Depth Information
7.
Write a script that creates a table named EmpCount. The table will have
two columns, one with data type CHAR(4) and the other with data type
INT. Name the columns Customer and Count. After creating the table,
insert rows into the table using the query in Question 5 as your source.
Before doing anything, the script should make sure that GeneralHardware
is the default database.
8.
How can you verify that the batch in Question 7 worked correctly? What
specific statements should you use?
