Smallint type : Smallint « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. Smallint

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