?? part11.cfm.htm
字號:
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312">
<META NAME="GENERATOR" CONTENT="Mozilla/4.04 [en] (Win95; I) [Netscape]">
<TITLE>歡迎光臨</TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
document.onmouseover = doDocumentOnMouseOver ;
document.onmouseout = doDocumentOnMouseOut ;
function doDocumentOnMouseOver() {
var eSrc = window.event.srcElement ;
if (eSrc.className == "item") {
window.event.srcElement.className = "highlight"; // change class
}
}
function doDocumentOnMouseOut() {
var eSrc = window.event.srcElement ;
if (eSrc.className == "highlight") {
window.event.srcElement.className = "item"; // change class
}
}
var bV=parseInt(navigator.appVersion);
NS4=(document.layers) ? true : false;
IE4=((document.all)&&(bV>=4))?true:false;
ver4 = (NS4 || IE4) ? true : false;
function expandIt(){return}
function expandAll(){return}
//-->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript1.2">
<!--
isExpanded = false;
function getIndex(el) {
ind = null;
for (i=0; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.id == el) {
ind = i;
break;
}
}
return ind;
}
function arrange() {
nextY = document.layers[firstInd].pageY + document.layers[firstInd].document.height;
for (i=firstInd+1; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.visibility != "hide") {
whichEl.pageY = nextY;
nextY += whichEl.document.height;
}
}
}
function initIt(){
if (NS4) {
for (i=0; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.id.indexOf("Child") != -1) whichEl.visibility = "hide";
}
arrange();
}
else {
tempColl = document.all.tags("DIV");
for (i=0; i<tempColl.length; i++) {
if (tempColl(i).className == "child") tempColl(i).style.display = "none";
}
}
}
function expandIt(el) {
if (!ver4) return;
if (IE4) {expandIE(el)} else {expandNS(el)}
}
function expandIE(el) {
whichEl = eval(el + "Child");
whichIm = event.srcElement;
if (whichEl.style.display == "none") {
whichEl.style.display = "block";
whichIm.src = "images/minus.gif";
}
else {
whichEl.style.display = "none";
whichIm.src = "images/icon-t.gif";
}
window.event.cancelBubble = true ;
}
function expandNS(el) {
whichEl = eval("document." + el + "Child");
whichIm = eval("document." + el + "Parent.document.images['imEx']");
if (whichEl.visibility == "hide") {
whichEl.visibility = "show";
whichIm.src = "images/minus.gif";
}
else {
whichEl.visibility = "hide";
whichIm.src = "images/icon-t.gif";
}
arrange();
}
function showAll() {
for (i=firstInd; i<document.layers.length; i++) {
whichEl = document.layers[i];
whichEl.visibility = "show";
}
}
function expandAll(isBot) {
newSrc = (isExpanded) ? "minus.gif" : "icon-t.gif";
if (NS4) {
document.images["imEx"].src = newSrc;
for (i=firstInd; i<document.layers.length; i++) {
whichEl = document.layers[i];
if (whichEl.id.indexOf("Parent") != -1) {
whichEl.document.images["imEx"].src = newSrc;
}
if (whichEl.id.indexOf("Child") != -1) {
whichEl.visibility = (isExpanded) ? "hide" : "show";
}
}
arrange();
if (isBot && isExpanded) scrollTo(0,document.layers[firstInd].pageY);
}
else {
divColl = document.all.tags("DIV");
for (i=0; i<divColl.length; i++) {
if (divColl(i).className == "child") {
divColl(i).style.display = (isExpanded) ? "none" : "block";
}
}
imColl = document.images.item("imEx");
for (i=0; i<imColl.length; i++) {
imColl(i).src = newSrc;
}
}
isExpanded = !isExpanded;
}
with (document) {
write("<STYLE TYPE='text/css'>");
if (NS4) {
write(".parent {font-size:9pt; line-height:10pt; color:black; text-decoration:none; margin-top: 5px; margin-bottom: 5px; position:absolute; visibility:hidden; color: black;}");
write(".child {text-decoration:none; font-size:9pt; line-height:10pt; position:absolute; visibility:hidden}");
write(".item { color: darkblue; text-decoration:none;}");
write(".regular {position:absolute; visibility:hidden}");
write("DIV { color:black; }")
}
else {
write(".child {font:12px/13px Times; display:none}");
write(".parent {font:12px/13px Times; color:black; font-weight:bold; text-decoration:none; margin-top: 5px; margin-bottom: 5px; color: black;}");
write(".item { color: darkblue; text-decoration:none;}");
write(".highlight { color: red; }");
write(".heada { font: 12px/13px; Times}");
write("DIV { color:black; }")
}
write("</STYLE>");
}
onload = initIt;
//-->
</SCRIPT>
</HEAD>
<BODY BGCOLOR="#FFFFFF" LINK="#000000" VLINK="#808080" ALINK="#000000" topmargin="11" leftmargin="15" marginwidth="15" marginheight="11">
<font size=2>第三部分 操作數據SQL</font><p>
<font size=2>第十一章 中級 SQL</font>
<DIV ID="elOneParent" CLASS="parent"><A HREF="#" class="item" onClick="expandIt('elOne'); return false"><IMG SRC="icon-t.gif" tppabs="http://210.74.168.175/guide/asp/part11/icon-t.gif" NAME="imEx" BORDER=0 HEIGHT=10 WIDTH=5></A><A HREF="#" class="item" onClick="expandIt('elOne'); return false">
<FONT COLOR="#000000"><FONT SIZE=-1>創建索引</FONT></FONT></A></DIV>
<DIV ID="elOneChild" CLASS="child">
<A HREF="11-1-1.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-1-1.cfm" class="item" target="right">.11-1-1 第一節</A>
<BR> <A HREF="11-1-2.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-1-2.cfm" class="item" target="right">.11-1-2 第二節</A>
</DIV>
<DIV ID="elTwoParent" CLASS="parent"><A HREF="#" class="item" onClick="expandIt('elTwo'); return false"><IMG SRC="icon-t.gif" tppabs="http://210.74.168.175/guide/asp/part11/icon-t.gif" NAME="imEx" BORDER=0 HEIGHT=10 WIDTH=5></A><A HREF="#" class="item" onClick="expandIt('elTwo'); return false">
<FONT COLOR="#000000"><a href="11-2.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-2.cfm" class="item" target="right"><FONT SIZE=-1>SQL核心語句</FONT></a></FONT></A>
</DIV>
<DIV ID="elTwoChild" CLASS="child">
</DIV>
<DIV ID="elThreeParent" CLASS="parent"><A HREF="#" class="item" onClick="expandIt('elThree'); return false"><IMG SRC="icon-t.gif" tppabs="http://210.74.168.175/guide/asp/part11/icon-t.gif" NAME="imEx" BORDER=0 HEIGHT=10 WIDTH=5></A><A HREF="#" class="item" onClick="expandIt('elThree'); return false">
<FONT COLOR="#000000"><a href="11-3.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-3.cfm" class="item" target="right"><FONT SIZE=-1>集合函數</FONT></a></FONT></A></DIV>
<DIV ID="elThreeChild" CLASS="child">
</DIV>
<DIV ID="elFourParent" CLASS="parent"><A HREF="#" class="item" onClick="expandIt('elFour'); return false"><IMG SRC="icon-t.gif" tppabs="http://210.74.168.175/guide/asp/part11/icon-t.gif" NAME="imEx" BORDER=0 HEIGHT=10 WIDTH=5></A><A HREF="#" class="item" onClick="expandIt('elFour'); return false">
<FONT COLOR="#000000"><FONT SIZE=-1>其它常用的SQL表達式，<br> 函數，和過程</FONT></FONT></A></DIV>
<DIV ID="elFourChild" CLASS="child">
<A HREF="11-4-1.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-1.cfm" class="item" target="right">.11-4-1 第一節</A>
<BR> <A HREF="11-4-2.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-2.cfm" class="item" target="right">.11-4-2 第二節</A>
<BR> <A HREF="11-4-3.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-3.cfm" class="item" target="right">.11-4-3 第三節</A>
<BR> <A HREF="11-4-4.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-4.cfm" class="item" target="right">.11-4-4 第四節</A>
<BR> <A HREF="11-4-5.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-5.cfm" class="item" target="right">.11-4-5 第五節</A>
<BR> <A HREF="11-4-6.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-6.cfm" class="item" target="right">.11-4-6 第六節</A>
<BR> <A HREF="11-4-7.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-7.cfm" class="item" target="right">.11-4-7 第七節</A>
<BR> <A HREF="11-4-8.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-8.cfm" class="item" target="right">.11-4-8 第八節</A>
<BR> <A HREF="11-4-9.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-9.cfm" class="item" target="right">.11-4-9 第九節</A>
<BR> <A HREF="11-4-10.cfm.htm" tppabs="http://210.74.168.175/guide/asp/part11/11-4-10.cfm" class="item" target="right">.11-4-10 第十節</A>
</DIV>
<DIV ID="elFiveParent" CLASS="parent"><A HREF="#" class="item" onClick="expandIt('elFive'); return false"><IMG SRC="icon-t.gif" tppabs="http://210.74.168.175/guide/asp/part11/icon-t.gif" NAME="imEx" BORDER=0 HEIGHT=10 WIDTH=5></A><A HREF="#" class="item" onClick="expandIt('elFive'); return false">
<FONT COLOR="#000000"><A HREF="../down.cfm.htm" tppabs="http://210.74.168.175/guide/asp/down.cfm" class="item" target="main"><FONT SIZE=-1>返回主目錄</FONT></FONT></A></DIV>
<SCRIPT LANGUAGE="JavaScript1.2">
<!--
if (NS4) {
firstEl = "elOneParent";
firstInd = getIndex(firstEl);
showAll();
arrange();
}
//-->
</SCRIPT>
</BODY>
</HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -