随笔分类 - SQL
摘要：--创建表格 CREATE TABLE STUDENT( STUDENT_ID CHAR(5) NOT NULL PRIMARY KEY, NAME VARCHAR(20) UNIQUE, GENDER CHAR(10) DEFAULT('MALE'), BIRTHDAY INT, SDEPT VARCHAR(15));--创建索引create index student_name on student(name)create table course( cno char(4) not null primary key, cname char(40), cpno char(4)
阅读全文
摘要：0 Feb 22 2006 4:26PM CONVERT(CHAR(19), 时间字段, 0) 1 02/22/06 CONVERT(CHAR(8), 时间字段, 1) 2 06.02.22 CONVERT(CHAR(8), 时间字段, 2) 3 22/02/06 CONVERT(CHAR(8), 时间字段, 3) 4 22.02.06 ...
阅读全文
