摘要:
Sorting:We may specify desc fordescending order(降序) or asc forascending order(升序), for each attribute;asce... 阅读全文
posted @ 2012-10-30 16:32
he_qiao_2010
阅读(70)
评论(0)
推荐(0)
摘要:
l Find coursesthat ran in Fall 2009 or in Spring 2010 (select course_idfrom section where sem = ‘Fall’ and... 阅读全文
posted @ 2012-10-30 16:31
he_qiao_2010
阅读(54)
评论(0)
推荐(0)
摘要:
%用来匹配任何字符串;_下划线用来匹配任何单个字符;字符串一般用单引号' '括起来;一般字符串运算会与like操作一起用;对于特殊字符会用到\进行转义; +(字符串串联)+=(字符串串联)%(通配符 - 需匹配的... 阅读全文
posted @ 2012-10-30 16:30
he_qiao_2010
阅读(110)
评论(0)
推荐(0)
摘要:
数据类型定义:lchar(n). Fixed length character string, with user-specified length n.lvarchar(n). Variable length... 阅读全文
posted @ 2012-10-30 16:17
he_qiao_2010
阅读(82)
评论(0)
推荐(0)
摘要:
SQL中的几种码:SuperKey:超码Candidate key:候选码Primary Key:主码Foreign Key:外码数据库中什么是超码、候选码、主码?码是数据系统中的基本概念。所谓码就是能唯一标识实... 阅读全文
posted @ 2012-10-30 16:08
he_qiao_2010
阅读(130)
评论(0)
推荐(0)

浙公网安备 33010602011771号