21 lines
2.8 KiB
SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/****************************************************************************************/
/* */
/* Kroenke, Auer, Vandenberg, and Yoder - Database Processing (15th Edition) Chapter 12 */
/* */
/* Heather Sweeney Designs Data Warehouse Database Load Tables */
/* */
/* These are the Microsoft SQL Server 2016 code solutions */
/* */
/****************************************************************************************/
INSERT INTO PRODUCT VALUES ('BK001', 'Book', 'Kitchen Remodeling Basics For Everyone');
INSERT INTO PRODUCT VALUES ('BK002', 'Book', 'Advanced Kitchen Remodeling For Everyone');
INSERT INTO PRODUCT VALUES ('BK003', 'Book', 'Kitchen Remodeling Dallas Style For Everyone');
INSERT INTO PRODUCT VALUES ('VB001', 'Video Companion', 'Kitchen Remodeling Basics');
INSERT INTO PRODUCT VALUES ('VB002', 'Video Companion', 'Advanced Kitchen Remodeling I');
INSERT INTO PRODUCT VALUES ('VB003', 'Video Companion', 'Kitchen Remodeling Dallas Style');
INSERT INTO PRODUCT VALUES ('VK001', 'Video', 'Kitchen Remodeling Basics');
INSERT INTO PRODUCT VALUES ('VK002', 'Video', 'Advanced Kitchen Remodeling');
INSERT INTO PRODUCT VALUES ('VK003', 'Video', 'Kitchen Remodeling Dallas Style');
INSERT INTO PRODUCT VALUES ('VK004', 'Video', 'Heather Sweeney Seminar Live in Dallas on 25-OCT-16');