示例2.sql

来自「SQL基础教程上的一些源码」· SQL 代码 · 共 11 行

CREATE table Products
(
ProductName  nvarchar(20) NOT NULL UNIQUE NONCLUSTERED,
ProductID  int PRIMARY KEY CLUSTERED,
Amount  int CHECK (Amount >= 1000 and Amount <= 2000),
Price money,
OutDay smalldatetime,
Country nvarchar(20) DEFAULT 'China',
Total  AS (Price * Amount),
Comment  nvarchar(4000)
)