|
2> CREATE TABLE discounts(
3> discounttype varchar(40) NOT NULL,
4> stor_id char(4) NULL ,
5> lowqty smallint NULL,
6> highqty smallint NULL,
7> discount dec(4,2) NOT NULL
8> )
9> GO
1>
2> insert discounts values('Initial Customer', NULL, NULL, NULL, 10.5)
3> insert discounts values('Volume Discount', NULL, 100, 1000, 6.7)
4> insert discounts values('Customer Discount', '8042', NULL, NULL, 5.0)
5> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
1>
1> drop table discounts;
2> GO
|