<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta http-equiv="Content-Language" content="zh-cn" />
<meta name="robots" content="all" />
<meta name="author" content="w3school.com.cn" />
<meta name="Copyright" content="Copyright W3school.com.cn All Rights Reserved." />
<meta name="MSSmartTagsPreventParsing" content="true" />
<meta http-equiv="imagetoolbar" content="false" />
<link rel="stylesheet" type="text/css" href="c3.css" />
<title>SQL 数据类型</title>
</head>
<body class="serverscripting">
<div id="wrapper">
<div id="header">
<a href="/index.html" title="w3school 在线教程" style="float:left;">w3school 在线教程</a>
<div id="ad_head">
<script type="text/javascript"><!--
google_ad_client = "pub-3381531532877742";
/* 728x90, 创建于 08-12-1 */
google_ad_slot = "7423315034";
google_ad_width = 728;
google_ad_height = 90;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>
</div>
<div id="navfirst">
<ul id="menu">
<li id="h"><a href="/h.htm" title="HTML 系列教程">HTML教程</a></li>
<li id="x"><a href="/x.htm" title="XML 系列教程">XML教程</a></li>
<li id="b"><a href="/b.htm" title="浏览器脚本系列教程">浏览器脚本</a></li>
<li id="s"><a href="/s.htm" title="服务器脚本系列教程">服务器脚本</a></li>
<li id="d"><a href="/d.htm" title=".NET (dotnet) 教程">dot net教程</a></li>
<li id="m"><a href="/m.htm" title="多媒体系列教程">多媒体教程</a></li>
<li id="w"><a href="/w.htm" title="网站构建手册">建站手册</a></li>
</ul>
</div><div id="navsecond">
<div id="course">
<h2>SQL 基础</h2>
<ul>
<li><a href="index.htm" title="SQL 教程">SQL 首页</a></li>
<li><a href="sql_intro.htm" title="SQL 简介">SQL 简介</a></li>
<li><a href="sql_syntax.htm" title="SQL 语法">SQL 语法</a></li>
<li><a href="sql_select.htm" title="SQL SELECT 语句">SQL select</a></li>
<li><a href="sql_distinct.htm" title="SQL SELECT DISTINCT 语句">SQL distinct</a></li>
<li><a href="sql_where.htm" title="SQL WHERE 子句">SQL where</a></li>
<li><a href="sql_and_or.htm" title="SQL AND & OR">SQL AND & OR</a></li>
<li><a href="sql_orderby.htm" title="SQL ORDER BY 语句">SQL Order By</a></li>
<li><a href="sql_insert.htm" title="SQL INSERT INTO 语句">SQL insert</a></li>
<li><a href="sql_update.htm" title="SQL UPDATE 语句">SQL update</a></li>
<li><a href="sql_delete.htm" title="SQL DELETE 语句">SQL delete</a></li>
</ul>
<h2>SQL 高级</h2>
<ul>
<li><a href="sql_top.htm" title="SQL TOP 子句">SQL Top</a></li>
<li><a href="sql_like.htm" title="SQL LIKE 运算符">SQL Like</a></li>
<li><a href="sql_wildcards.htm" title="SQL 通配符">SQL 通配符</a></li>
<li><a href="sql_in.htm" title="SQL IN">SQL In</a></li>
<li><a href="sql_between.htm" title="SQL BETWEEN">SQL Between</a></li>
<li><a href="sql_alias.htm" title="SQL Alias(别名)">SQL Aliases</a></li>
<li><a href="sql_join.htm" title="SQL JOIN">SQL Join</a></li>
<li><a href="sql_join_inner.htm" title="SQL INNER JOIN 关键字">SQL Inner Join</a></li>
<li><a href="sql_join_left.htm" title="SQL LEFT JOIN 关键字">SQL Left Join</a></li>
<li><a href="sql_join_right.htm" title="SQL RIGHT JOIN 关键字">SQL Right Join</a></li>
<li><a href="sql_join_full.htm" title="SQL FULL JOIN 关键字">SQL Full Join</a></li>
<li><a href="sql_union.htm" title="SQL UNION 和 UNION ALL">SQL Union</a></li>
<li><a href="sql_select_into.htm" title="SQL SELECT INTO 语句">SQL Select Into</a></li>
<li><a href="sql_create_db.htm" title="SQL CREATE DATABASE 语句">SQL Create DB</a></li>
<li><a href="sql_create_table.htm" title="SQL CREATE TABLE 语句">SQL Create Table</a></li>
<li><a href="sql_constraints.htm" title="SQL 约束">SQL Constraints</a></li>
<li><a href="sql_notnull.htm" title="SQL NOT NULL 约束">SQL Not Null</a></li>
<li><a href="sql_unique.htm" title="SQL UNIQUE 约束">SQL Unique</a></li>
<li><a href="sql_primarykey.htm" title="SQL PRIMARY KEY 约束">SQL Primary Key</a></li>
<li><a href="sql_foreignkey.htm" title="SQL FOREIGN KEY 约束">SQL Foreign Key</a></li>
<li><a href="sql_check.htm" title="SQL CHECK 约束">SQL Check</a></li>
<li><a href="sql_default.htm" title="SQL DEFAULT 约束">SQL Default</a></li>
<li><a href="sql_create_index.htm" title="SQL CREATE INDEX 语句">SQL Create Index</a></li>
<li><a href="sql_drop.htm" title="SQL 撤销索引、表以及数据库">SQL Drop</a></li>
<li><a href="sql_alter.htm" title="SQL ALTER TABLE">SQL Alter</a></li>
<li><a href="sql_autoincrement.htm" title="SQL AUTO INCREMENT 字段">SQL Increment</a></li>
<li><a href="sql_view.htm" title="SQL VIEW(视图)">SQL View</a></li>
<li><a href="sql_dates.htm" title="SQL Date 函数">SQL Date</a></li>
<li><a href="sql_null_values.htm" title="SQL NULL 值">SQL Nulls</a></li>
<li><a href="sql_isnull.htm" title="SQL NULL 函数">SQL isnull()</a></li>
<li><a href="sql_datatypes.htm" title="SQL 数据类型">SQL 数据类型</a></li>
<li><a href="sql_server.htm" title="SQL 服务器 - RDBMS">SQL 服务器</a></li>
</ul>
<h2>SQL 函数</h2>
<ul class="small">
<li><a href="sql_functions.htm" title="SQL 函数">SQL functions</a></li>
<li><a href="sql_func_avg.htm" title="SQL AVG() 函数">SQL avg()</a></li>
<li><a href="sql_func_count.htm" title="SQL COUNT() 函数">SQL count()</a></li>
<li><a href="sql_func_first.htm" title="SQL FIRST() 函数">SQL first()</a></li>
<li><a href="sql_func_last.htm" title="SQL LAST() 函数">SQL last()</a></li>
<li><a href="sql_func_max.htm" title="SQL MAX() 函数">SQL max()</a></li>
<li><a href="sql_func_min.htm" title="SQL MIN() 函数">SQL min()</a></li>
<li><a href="sql_func_sum.htm" title="SQL SUM() 函数">SQL sum()</a></li>
<li><a href="sql_groupby.htm" title="SQL GROUP BY 语句">SQL Group By</a></li>
<li><a href="sql_having.htm" title="SQL HAVING 子句">SQL Having</a></li>
<li><a href="sql_func_ucase.htm" title="SQL UCASE() 函数">SQL ucase()</a></li>
<li><a href="sql_func_lcase.htm" title="SQL LCASE() 函数">SQL lcase()</a></li>
<li><a href="sql_func_mid.htm" title="SQL MID() 函数">SQL mid()</a></li>
<li><a href="sql_func_len.htm" title="SQL LEN() 函数">SQL len()</a></li>
<li><a href="sql_func_round.htm" title="SQL ROUND() 函数">SQL round()</a></li>
<li><a href="sql_func_now.htm" title="SQL NOW() 函数">SQL now()</a></li>
<li><a href="sql_func_format.htm" title="SQL FORMAT() 函数">SQL format()</a></li>
</ul>
<h2>SQL 总结</h2>
<ul>
<li><a href="sql_quickref.htm" title="SQL 快速参考">SQL 快速索引</a></li>
<li><a href="sql_summary.htm" title="我们已经学习了 SQL,下一步学习什么呢?">SQL 总结</a></li>
</ul>
<h2>实例/测验</h2>
<ul>
<li><a href="sql_quiz.htm" title="SQL 测验">SQL 测验</a></li>
</ul>
</div>
<div id="selected">
<h2>建站手册</h2>
<ul>
<li><a href="/site/index.htm" title="网站构建">网站构建</a></li>
<li><a href="/w3c/index.htm" title="万维网联盟 (W3C)">万维网联盟 (W3C)</a></li>
<li><a href="/browsers/index.htm" title="浏览器信息">浏览器信息</a></li>
<li><a href="/quality/index.htm" title="网站品质">网站品质</a></li>
<li><a href="/semweb/index.htm" title="语义网">语义网</a></li>
<li><a href="/careers/index.htm" title="职业规划">职业规划</a></li>
<li><a href="/hosting/index.htm" title="网站主机">网站主机</a></li>
</ul>
<h2><a href="/about/index.htm" title="关于 W3School" id="link_about">关于 W3School</a></h2>
<h2><a href="/about/about_helping.htm" title="帮助 W3School" id="link_help">帮助 W3School</a></h2>
</div>
</div>
<div id="maincontent">
<h1>SQL 数据类型</h1>
<div id="tpn">
<ul class="prenext">
<li class="pre"><a href="sql_isnull.htm">Previous Page</a></li>
<li class="next"><a href="sql_server.htm">Next Page</a></li>
</ul>
</div>
<div>
<p><strong>Microsoft Access、MySQL 以及 SQL Server 所使用的数据类型和范围。</strong></p>
</div>
<div>
<h2>Microsoft Access 数据类型</h
- 1
- 2
- 3
- 4
- 5
- 6
前往页