1.
Open SQL Server Management Studio 2008 and connect to your server.
2.
Create a new database and name it CrystalFormulas.
3.
This database will contain only one table called SalesHeader. Create
this table with the following fields.
|
Field Name
|
Type
|
Allow Nulls
|
|
SalesHeaderId
|
Int (Identity)
|
No
|
|
SalesDate
|
DateTime
|
No
|
|
Total
|
Money
|
No
|
I pre-populated this table with records for January through
June. You can download the script to create this table and the seed records here.
You can run this script in SQL Management Studio to build the table and insert
the records or you can comment out the creation of the table and just run the
insert statements if you created the table manually.
You can use either Integrated Security when connecting to
this database or create a SQL Login. Either way you need to remember which
method you used when you are ready to connect to the database as defined in the
steps below.
