3.4 Adding Test Data
We need to get test data into the product table in order to develop our stored procedures. We’ll insert three records into the table using standard SQL statements. Copy, paste and run this SQL on your development database.
insert into product (product_name, start_date)
values ('Blue Widget 2007', '1 Jan 2007')
go
Note that we don’t specify the identity column (product_id) – SQL Server inserts a value for us. To see this, run a quick select against the table: select * from product. Now for the next two records:
insert into product (product_name, start_date)
values ('Pink Widget 2009', '1 Jan 2009')
go
insert into product (product_name, start_date)
values ('Grey Widget 2005', '1 Jan 2005')
go