📄 default.asp@output=print
字号:
<!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" />
<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>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
<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 & 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>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -