7-14.sql

包括本书所有的源代码。所有程序均在Windows 2000+IIS5.0+SQL Server2000下调试通过。所有程序

CREATE TABLE testDefault
(
	stu_id 		int IDENTITY(100000,1) PRIMARY KEY,
	Firstname 		VARCHAR(10) NOT NULL,
	Lastname 		VARCHAR(10) NOT NULL,
	Sex 			VARCHAR(30) DEFAULT 'M'
)
INSERT INTO testDefault(Firstname,Lastname) VALUES('xiao','zhou')

SELECT * FROM testDefault