📄 sql server.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0055)http://www.accessoft.com/Article_Show.asp?ArticleID=311 -->
<HTML><HEAD><TITLE>Sql Server 和 Access 操作数据库结构Sql语句</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<STYLE type=text/css>A {
TEXT-DECORATION: none
}
A:hover {
COLOR: #cc0000
}
A:link {
COLOR: #000000
}
A:visited {
COLOR: #000000
}
BODY {
FONT-SIZE: 9pt; BACKGROUND: #eeeeee
}
TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 150%; FONT-FAMILY: 宋体
}
INPUT {
BORDER-RIGHT: #ff9900 1px solid; BORDER-TOP: #ff9900 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #ff9900 1px solid; COLOR: #000000; BORDER-BOTTOM: #ff9900 1px solid; HEIGHT: 18px; BACKGROUND-COLOR: #f6f6f6
}
BUTTON {
FONT-SIZE: 9pt; HEIGHT: 20px
}
SELECT {
FONT-SIZE: 9pt; HEIGHT: 20px
}
.border {
BORDER-RIGHT: #ff9900 1px solid; BORDER-TOP: #ff9900 1px solid; BORDER-LEFT: #ff9900 1px solid; BORDER-BOTTOM: #ff9900 1px solid
}
.border2 {
BACKGROUND: #ffffff; BORDER-BOTTOM: #ff9900 1px solid
}
.title_txt {
BACKGROUND: url(Skin/3/topBar_bg_20.gif)
}
.title {
BACKGROUND: url(Skin/3/title.gif); HEIGHT: 22px
}
.tdbg {
BACKGROUND: #ffffff; LINE-HEIGHT: 150%
}
.txt_css {
BACKGROUND: url(Skin/3/txt_css.gif); HEIGHT: 36px
}
.title_lefttxt {
}
.title_left {
BACKGROUND: url(Skin/3/title_left.gif); HEIGHT: 39px
}
.tdbg_left {
BACKGROUND: url(Skin/3/tdbg_left.gif); LINE-HEIGHT: 150%
}
.title_left2 {
BACKGROUND: url(Skin/3/L_BOTTOM.GIF); HEIGHT: 25px
}
.tdbg_left2 {
BACKGROUND: url(Skin/3/tdbg_left2.gif); HEIGHT: 13px
}
.tdbg_leftall {
BACKGROUND: #f6f6f6
}
.title_maintxt {
FILTER: DropShadow(Color=#ffffff, OffX=1, OffY=1, Positive=1)
}
.title_main {
BACKGROUND: url(Skin/3/title_main.gif); HEIGHT: 22px
}
.tdbg_main {
BACKGROUND: url(Skin/3/tdbg_main2.GIF); LINE-HEIGHT: 100%
}
.title_main2 {
BACKGROUND: url(Skin/3/maintop.gif); HEIGHT: 202px
}
.tdbg_main2 {
BACKGROUND: url(Skin/3/tdbg_main3.GIF); HEIGHT: 27px
}
.tdbg_mainall {
BACKGROUND: url(Skin/3/kt01-p1.GIF)
}
.title_righttxt {
FILTER: Glow(Color=#ffffff, Strength=5)
}
.title_right {
BACKGROUND: url(Skin/3/title_right.gif); HEIGHT: 31px
}
.tdbg_right {
BACKGROUND: #ffffff
}
.title_right2 {
BACKGROUND: url(Skin/3/title_right2.gif); HEIGHT: 22px
}
.tdbg_right2 {
BACKGROUND: url(Skin/3/tdbg_right2.gif); HEIGHT: 22px
}
.tdbg_rightall {
BORDER-RIGHT: #ff9900 1px solid; BORDER-TOP: #ff9900 1px solid; BACKGROUND: #fffce1; BORDER-LEFT: #ff9900 1px solid; BORDER-BOTTOM: #ff9900 1px solid
}
.topborder {
BACKGROUND-IMAGE: url(Skin/3/topborder.gif)
}
.nav_top {
BACKGROUND-IMAGE: url(Skin/3/nav_top.gif); HEIGHT: 25px
}
.nav_main {
BACKGROUND: url(Skin/3/nav_main.gif); LINE-HEIGHT: 150%; HEIGHT: 134px
}
.nav_bottom {
BACKGROUND-IMAGE: url(Skin/3/nav_bottom.gif)
}
.nav_menu {
BACKGROUND: url(Skin/3/nav_menu.gif); HEIGHT: 24px
}
.menu {
BORDER-RIGHT: 1px; BORDER-TOP: 1px; BORDER-LEFT: 1px; WIDTH: 97%; BORDER-BOTTOM: 1px; BACKGROUND-COLOR: #ff9900
}
TD.MenuBody {
BACKGROUND-COLOR: #fffce1
}
</STYLE>
<META content="MSHTML 6.00.2800.1479" name=GENERATOR></HEAD>
<BODY><IFRAME src="Sql Server.files/stat1.htm" frameBorder=0 width=0
scrolling=no height=0></IFRAME>
<SCRIPT language=JavaScript type=text/JavaScript>
function HideMenu()
{
}
</SCRIPT>
<SCRIPT language=JavaScript1.2 src="Sql Server.files/stm31.js"
type=text/javascript></SCRIPT>
<SCRIPT language=JavaScript type=text/JavaScript>
//树形导航的JS代码
document.write("<style type=text/css>#master {LEFT: -200px; POSITION: absolute; TOP: 25px; VISIBILITY: visible; Z-INDEX: 999}</style>")
document.write("<table id=master width='218' border='0' cellspacing='0' cellpadding='0'><tr><td><img border=0 height=6 src=images/menutop.gif width=200></td><td rowspan='2' valign='top'><img id=menu onMouseOver=javascript:expand() border=0 height=70 name=menutop src=images/menuo.gif width=18></td></tr>");
document.write("<tr><td valign='top'><table width='100%' border='0' cellspacing='5' cellpadding='0'><tr><td height='400' valign='top'><table width=100% height='100%' border=1 cellpadding=0 cellspacing=5 bordercolor='#666666' bgcolor=#ecf6f5 style=FILTER: alpha(opacity=90)><tr>");
document.write("<td height='10' align='center' bordercolor='#ecf6f5'><font color=999900><strong>栏 目 树 形 导 航</strong></font></td></tr><tr><td valign='top' bordercolor='#ecf6f5'>");
document.write("<iframe width=100% height=100% src='classtree.asp?ChannelID=2' frameborder=0></iframe></td></tr></table></td></tr></table></td></tr></table>");
var ie = document.all ? 1 : 0
var ns = document.layers ? 1 : 0
var master = new Object("element")
master.curLeft = -200; master.curTop = 10;
master.gapLeft = 0; master.gapTop = 0;
master.timer = null;
if(ie){var sidemenu = document.all.master;}
if(ns){var sidemenu = document.master;}
setInterval("FixY()",100);
function moveAlong(layerName, paceLeft, paceTop, fromLeft, fromTop){
clearTimeout(eval(layerName).timer)
if(eval(layerName).curLeft != fromLeft){
if((Math.max(eval(layerName).curLeft, fromLeft) - Math.min(eval(layerName).curLeft, fromLeft)) < paceLeft){eval(layerName).curLeft = fromLeft}
else if(eval(layerName).curLeft < fromLeft){eval(layerName).curLeft = eval(layerName).curLeft + paceLeft}
else if(eval(layerName).curLeft > fromLeft){eval(layerName).curLeft = eval(layerName).curLeft - paceLeft}
if(ie){document.all[layerName].style.left = eval(layerName).curLeft}
if(ns){document[layerName].left = eval(layerName).curLeft}
}
if(eval(layerName).curTop != fromTop){
if((Math.max(eval(layerName).curTop, fromTop) - Math.min(eval(layerName).curTop, fromTop)) < paceTop){eval(layerName).curTop = fromTop}
else if(eval(layerName).curTop < fromTop){eval(layerName).curTop = eval(layerName).curTop + paceTop}
else if(eval(layerName).curTop > fromTop){eval(layerName).curTop = eval(layerName).curTop - paceTop}
if(ie){document.all[layerName].style.top = eval(layerName).curTop}
if(ns){document[layerName].top = eval(layerName).curTop}
}
eval(layerName).timer=setTimeout('moveAlong("'+layerName+'",'+paceLeft+','+paceTop+','+fromLeft+','+fromTop+')',30)
}
function setPace(layerName, fromLeft, fromTop, motionSpeed){
eval(layerName).gapLeft = (Math.max(eval(layerName).curLeft, fromLeft) - Math.min(eval(layerName).curLeft, fromLeft))/motionSpeed
eval(layerName).gapTop = (Math.max(eval(layerName).curTop, fromTop) - Math.min(eval(layerName).curTop, fromTop))/motionSpeed
moveAlong(layerName, eval(layerName).gapLeft, eval(layerName).gapTop, fromLeft, fromTop)
}
var expandState = 0
function expand(){
if(expandState == 0){setPace("master", 0, 10, 10); if(ie){document.menutop.src = "images/menui.gif"}; expandState = 1;}
else{setPace("master", -200, 10, 10); if(ie){document.menutop.src = "images/menuo.gif"}; expandState = 0;}
}
function FixY(){
if(ie){sidemenu.style.top = document.body.scrollTop+10}
if(ns){sidemenu.top = window.pageYOffset+10}
}
</SCRIPT>
<SCRIPT language=JavaScript type=text/JavaScript>
//双击鼠标滚动屏幕的代码
var currentpos,timer;
function initialize()
{
timer=setInterval ("scrollwindow ()",30);
}
function sc()
{
clearInterval(timer);
}
function scrollwindow()
{
currentpos=document.body.scrollTop;
window.scroll(0,++currentpos);
if (currentpos !=document.body.scrollTop)
sc();
}
document.onmousedown=sc
document.ondblclick=initialize
</SCRIPT>
<SCRIPT language=JavaScript type=text/JavaScript>
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</SCRIPT>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -