CREATE TABLE [图书表]
(
BookNo nvarchar(6) NOT NULL PRIMARY KEY,
BookName nvarchar(30) NOT NULL,
Author varbinary(10) NOT NULL,
PublishDate smalldatetime NULL,
Price numeric(18, 1) NULL /*这里整数部分,为什么是三位?*/
) ON [PRIMARY]
用SQL语句,在定义表的同时定义数据的完整性约束:
CREATE TABLE [图书表]
(
BookNo nvarchar(6) NOT NULL PRIMARY KEY,
BookName nvarchar(30) NOT NULL,
Author varbinary(10) NOT NULL,
PublishDate smalldatetime NULL,
Price numeric(18, 1) NULL /*这里整数部分,为什么是三位?*/
) ON [PRIMARY]