SQL server基本操作(一)
--create databaseCREATE DATABASE MyDBGO--use databaseUSE MyDBGO--create tableCREATE TABLE Teacher(id INT IDENTITY PRIMARY KEY,tname VARCHAR(10) NOT NULL,tsex BIT NOT NULL,tage INT CHECK(tage>18 AND tage<80))GO--insert dataINSERT INTO Teacher values('张老师',0,25)INSERT INTO Teacher values('王老师',1,45)INSERT INTO Teacher values('李老师',0,30)GO--select dataSELECT * FROM TeacherGO--select data as other nameSELECT id AS '编号',tname AS '称谓',tsex AS '性别',tage AS '年龄' FROM TeacherGO--select data as other valueSELECT id AS '编号',tname AS '称谓',CASE tsex WHEN 0 THEN '女' ELSE '男' END AS '性别',tage AS '年龄' FROM Teacher?
?
?