⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 default.asp

📁 W3Schools tutorial..web designing
💻 ASP
字号:
🔍 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>

<title>SQL Tutorial</title>
 
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />

<meta name="Description" content="Well organized easy to understand SQL tutorial with lots of examples. Including PHP, ASP, ADO, Oracle, Access, SQL Server. Related: HTML, JavaScript, XML, XQuery" />

<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />

<link rel="stylesheet" type="text/css" href="../stdtheme.css" />

<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>

</head>
<body>

<a name="top"></a>
<table cellpadding="0" cellspacing="0" width="100%" bgcolor="#808080">
<tr>
<td width="234" valign="top">
<a href="../default.htm"><img src="../images/w3default80.jpg" border="0" alt="W3Schools" /></a>
</td>
<th valign="middle" align="left" class="right">
<iframe style="background-color:#808080" src="../banners/bannerframe.asp@adpartner=xmlmaster" height="90" width="728"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>

<br /></th>
</tr>
</table>

<table style="margin-left:1px" width="800px" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="137" class="content" valign="top"><br />
<a class="left" href="../default.asp" target="_top">
<img src="../images/homeicon.gif" border="0" alt="home" /></a>
<a class="left" href="../default.asp" target="_top">
<b>HOME</b></a>
<br /><br />
<b>SQL Basic</b>
<br />
<a class="left" target="_top" href="default.asp" style='font-weight:bold;'>SQL HOME</a><br />
<a class="left" target="_top" href="sql_intro.asp" >SQL Intro</a><br />
<a class="left" target="_top" href="sql_select.asp" >SQL Select</a><br />
<a class="left" target="_top" href="sql_where.asp" >SQL Where</a><br />
<a class="left" target="_top" href="sql_insert.asp" >SQL Insert</a><br />
<a class="left" target="_top" href="sql_update.asp" >SQL Update</a><br />
<a class="left" target="_top" href="sql_delete.asp" >SQL Delete</a><br />
<br />
<b>SQL Demo</b><br />
<a class="left" target="_top" href="sql_tryit.asp" >SQL Try It</a><br />
<br />
<b>SQL Advanced</b><br />
<a class="left" target="_top" href="sql_orderby.asp" >SQL Order By</a><br />
<a class="left" target="_top" href="sql_and_or.asp" >SQL and &amp; or</a><br />
<a class="left" target="_top" href="sql_in.asp" >SQL In</a><br />
<a class="left" target="_top" href="sql_between.asp" >SQL Between</a><br />
<a class="left" target="_top" href="sql_alias.asp" >SQL Aliases</a><br />
<a class="left" target="_top" href="sql_join.asp" >SQL Join</a><br />
<a class="left" target="_top" href="sql_union.asp" >SQL Union</a><br />
<a class="left" target="_top" href="sql_create.asp" >SQL Create</a><br />
<a class="left" target="_top" href="sql_drop.asp" >SQL Drop</a><br />
<a class="left" target="_top" href="sql_alter.asp" >SQL Alter</a><br />
<a class="left" target="_top" href="sql_functions.asp" >SQL Functions</a><br />
<a class="left" target="_top" href="sql_groupby.asp" >SQL Group By</a><br />
<a class="left" target="_top" href="sql_select_into.asp" >SQL Select Into</a><br />
<a class="left" target="_top" href="sql_view.asp" >SQL Create View</a><br />
<a class="left" target="_top" href="sql_server.asp" >SQL Server</a><br />
<br />
<a class="left" target="_top" href="sql_quickref.asp" >SQL Quick Ref</a><br />
<a class="left" target="_top" href="sql_summary.asp" >SQL Summary</a><br />
<br />
<b>SQL Quiz</b><br />
<a class="left" target="_top" href="sql_quiz.asp" >SQL Quiz</a><br />
<br />
<b>Selected Reading</b><br />
<a class="left" target="_top" href="../browsers/browsers_stats.asp">Web Statistics</a><br />
<a class="left" target="_top" href="../site/site_glossary.asp">Web Glossary</a><br />
<a class="left" target="_top" href="../hosting/default.asp">Web Hosting</a><br />
<a class="left" target="_top" href="../quality/default.asp">Web Quality</a><br /><br />
<a class="left" target="_top" href="../forum/default.asp">W3Schools Forum</a><br /><br />
<a class="left" target="_top" href="../about/about_helping.asp">Helping W3Schools</a><br /><br />
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*LeftLinkUnit*/
google_ad_slot = "4854527104";
google_ad_width = 120;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td>
<td valign="top">
<table style="border: 1px solid gray" width="100%" bgcolor="#FFFFFF" border="0" cellpadding="5" cellspacing="0">
<tr>
<td>

<h1>SQL Tutorial</h1>
<a href="../default.asp"><img alt="previous" border="0" src="../images/btn_previous.gif" /></a>
 <a href="sql_intro.asp"><img alt="next" border="0" src="../images/btn_next.gif" width="100" height="20" /></a>
<hr />

<h2 class="tutheader">SQL Tutorial</h2>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="middle" width="150"><img src="SQL2.gif" border="0" alt="SQL" width="94" height="77" /></td>
<td valign="top">
<p><b>SQL is a standard computer language for accessing and manipulating 
databases.</b></p>
<p><b>In this tutorial you will learn how to use SQL to access and manipulate data in Oracle, 
Sybase, SQL Server, DB2, Access, and other database systems.</b></p>
<p><a href="sql_intro.asp"><b>Start learning SQL now!</b></a></p>
</td>
</tr>
</table>
<br />
<h2 class="tutheader">Table Of Content</h2>
<p><a href="sql_intro.asp">SQL Intro</a><br />
An introduction to SQL.</p>

<p><a href="sql_select.asp">SQL SELECT</a><br />
How the SELECT statement is used to select data from a database.</p>

<p><a href="sql_where.asp">SQL WHERE</a><br />
How the WHERE clause is used to conditionally select data.</p>

<p><a href="sql_insert.asp">SQL INSERT INTO</a><br />
How the INSERT INTO statement inserts new records (rows) into a database table.</p>

<p><a href="sql_update.asp">SQL UPDATE</a><br />
How to modify data in a database using the UPDATE statement.</p>

<p><a href="sql_delete.asp">SQL DELETE</a><br />
How to delete records (rows) in a database, using the DELETE statement.</p>

<h2 class="tutheader">SQL Demo</h2>
<p><a href="sql_tryit.asp">SQL Try-It-Yourself</a><br />
Try some SQL statements of your own.</p>

<h2 class="tutheader">SQL Advanced</h2>

<p><a href="sql_orderby.asp">SQL ORDER BY</a><br />
The ORDER BY keyword is used to sort the result.</p>

<p><a href="sql_and_or.asp">SQL AND &amp; OR</a><br />
AND and OR join two or more conditions in a WHERE clause.</p>

<p><a href="sql_in.asp">SQL IN</a><br />
The IN operator may be used if you know the exact value(s) to search for.</p>
<p><a href="sql_between.asp">SQL BETWEEN</a><br />
The BETWEEN operator selects a range of data between two values.</p>
<p><a href="sql_alias.asp">SQL ALIAS</a><br />
Aliases can be used for column names and table names.</p>
<p><a href="sql_join.asp">SQL JOIN</a><br />
How to use the JOIN operator to select data from two or more tables. </p>
<p><a href="sql_union.asp">SQL UNION</a><br />
The UNION operator is used to select related information from two tables.</p>
<p><a href="sql_create.asp">SQL CREATE</a><br />
How to create a new database and / or a new database table.</p>
<p><a href="sql_drop.asp">SQL DROP</a><br />
How to drop (delete) a database and /or a database table.</p>
<p><a href="sql_alter.asp">SQL ALTER</a><br />
How to user ALTER to add or delete table columns.</p>
<p><a href="sql_functions.asp">SQL Functions</a><br />
SQL has a lot of built-in functions for counting and calculations.</p>
<p><a href="sql_groupby.asp">SQL GROUP BY</a><br />
How to use GROUP BY to group aggregated data.</p>
<p><a href="sql_select_into.asp">SQL SELECT INTO</a><br />
How to use SELECT INTO to save selected data in tables (create backup copies).</p>
<p><a href="sql_view.asp">SQL CREATE VIEW</a><br />
How to create a virtual table using CREATE VIEW.</p>
<p><a href="sql_server.asp">SQL Server</a><br />
About Database Management Systems (DBMS).</p>
<p><a href="sql_quickref.asp">SQL Quick Reference</a><br />
An SQL Quick Reference. Print it, fold it, and put it in your pocket.</p>
<p><a href="sql_summary.asp">SQL Summary</a><br />
A summary of this tutorial.</p>
<h2 class="tutheader">SQL Quiz Test</h2>
<p><a href="sql_quiz.asp">Start SQL quiz!</a><br />
Test your SQL skills at W3Schools! </p>

<hr />
<a href="../default.asp"><img alt="previous" border="0" src="../images/btn_previous.gif" width="100" height="20" /></a>
 <a href="sql_intro.asp"><img alt="next" border="0" src="../images/btn_next.gif" width="100" height="20" /></a>

<br />
<hr />

<!-- **** SPOTLIGHTS 1 **** -->

<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->


<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />

<center>

<iframe style="background-color:#ffffff" src="../banners/aspallbannerframe.asp" height="60" width="468" marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>

</center>
<hr />

<table>
<tr>
<td><img src="../images/diploma.jpg" alt="diploma" /></td>
<td>&nbsp;&nbsp;</td>
<td valign="top">
<h2>Get Your Diploma!</h2>
<p>W3Schools' Online Certification Program is the perfect solution for busy 
professionals who need to balance work, family, and career building.</p>
<p>The <a href="../cert/default.asp">HTML Certificate</a> is for developers who want to document their knowledge of HTML, XHTML, and CSS.</p>
<p>The <a href="../cert/default.asp">ASP Certificate</a> is for developers who want to document their knowledge of ASP, SQL, and ADO.</p>
</td>
</tr>
</table>
<br />


<hr />

<!-- **** END SPOTLIGHTS **** -->

</td></tr>

<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='default.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>

</table>
</td></tr>
</table>
</td>


<td width="145" align="center" valign="top">




<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=sql" height="1850" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>

</td>
</tr></table>

</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -