7-14.sql

asp开发 asp开发 asp开发 asp开发

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