7-14.sql

来自「asp开发 asp开发 asp开发 asp开发」· SQL 代码 · 共 11 行

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