Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Access´´½¨±í

Ò»¡¢´´½¨Ò»ÕÅ¿Õ±í£º
Sql="Create TABLE [±íÃû]"
¶þ¡¢´´½¨Ò»ÕÅÓÐ×Ö¶ÎµÄ±í£º
Sql="Create TABLE [±íÃû]([×Ö¶ÎÃû1] MEMO NOT NULL, [×Ö¶ÎÃû2] MEMO, [×Ö¶ÎÃû3] COUNTER NOT NULL, [×Ö¶ÎÃû4] DATETIME, [×Ö¶ÎÃû5] TEXT(200), [×Ö¶ÎÃû6] TEXT(200))
×Ö¶ÎÀàÐÍ£º
2 : "SmallInt", // ÕûÐÍ
3 : "Int", // ³¤ÕûÐÍ
4 : "Real", // µ¥¾«¶ÈÐÍ
5 : "Float", // Ë«¾«¶ÈÐÍ
6 : "Money", // »õ±Ò
7 : "DateTime", // ÈÕÆÚʱ¼ä
11 : "Bit", // ÊÇ·ñ
13 : "TimeStamp",
17 : "TinyInt", // ×Ö½Ú
72 : "UniqueIdentifier", // ͬ²½¸´ÖÆ ID
128 : "Binary",
129 : "Char",
130 : "NChar",
131 : "Decimal", // СÊý
133 : "DateTime",
135 : "SmallDateTime",
200 : "VarChar",
201 : "Text",
202 : "VarChar", // Îı¾
203 : "Text", // ±¸×¢
204 : "Binary", // ¶þ½øÖÆ
205 : "Image" // OLE ¶ÔÏó
ÒÔÏÂ×Ö¶ÎΪÎÞ±àÂë×ֶΣ¨NChar¡¢NVarchar¡¢NTextÐÍ£©
8,128,130,202,203,204,205
ÒÔÏÂ×Ö¶ÎΪ°´µ±Ç°ÏµÍ³ÄÚÂë±àÂëµÄ×ֶΣ¨AspÖпÉÓÃCodePage=936¾ÀÕýΪgb2312ÄÚÂ룩
129,200,201
ÔÚÏÖÓеıíÖÐÔö¼Ó×ֶΣº
Sql="alter table [±íÃû] add column [×Ö¶ÎÃû] varchar(200)"
ÐÞ¸Ä×Ö¶ÎÀàÐÍ£º
Sql="alter table [±íÃû] Alter COLUMN ×Ö¶ÎÃû] varchar(50)"
ɾ³ý±í£º
Sql="Drop table [±íÃû]"
ɾ³ý×ֶΣº
sql="alter table [±íÃû] drop [×Ö¶ÎÃû]"
ÐÞ¸Ä×ֶΣºAlter TABLE [±íÃû] Alter COLUMN [×Ö¶ÎÃû] ÀàÐÍ(´óС) NULL
н¨Ô¼Êø£ºAlter TABLE [±íÃû] ADD CONSTRAINT Ô¼ÊøÃû CHECK ([Ô¼Êø×Ö¶Î]


Ïà¹ØÎĵµ£º

VS2010Öд´½¨×Ô¶¨ÒåSQL Rule£¨ºÂÏÜç⣩

VS2010ÒѾ­·¢²¼¼¸Ììʱ¼äÁË£¬Ò»Ð©ÐµÄÌØÐÔÌØ±ðÒýÈËעĿ£¬±ÈÈ磺 ÐÔÄܵÄÎȶ¨ºÍÌáÉý£¬±íÏÖÔÚWPF GUIºÍWPFÎı¾³ÊÏÖ¡£ Windows Azure ToolsÄ£°å¡£ ¶àÏÔʾÆ÷Ö§³Ö£¬Êä³ö´°¿Ú£¬Ààͼ´°¿Ú£¬´úÂ붨Òå´°¿ÚµÈÌṩ¸¨ÖúÐÅÏ¢µÄ´°¿Ú·ÅÖÃÔÚ¸±ÏÔʾÆ÷ÖС£ ¶Ô²¢ÐмÆË㿪·¢µÄ´óÁ¿Ö§³Ö¡£ °üº¬ÁËSharePointµÄÏîĿģ°åºÍµ÷ÊÔÖ§³Ö ......

[MySQLÓÅ»¯] ÈçºÎ²éÕÒSQLЧÂʵØÏµÄÔ­Òò


[MySQLÓÅ»¯] -- ÈçºÎ²éÕÒSQLЧÂʵØÏµÄÔ­Òò
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chusong
²éѯµ½Ð§ÂÊµÍµÄ SQL Óï¾ä ºó£¬¿ÉÒÔͨ¹ý EXPLAIN »òÕß DESC ÃüÁî»ñÈ¡ MySQL ÈçºÎÖ´ÐÐ SELECT Óï¾äµÄÐÅÏ¢£¬°üÀ¨ÔÚ SELECT Óï¾äÖ´Ðйý³ÌÖбíÈçºÎÁ¬½ÓºÍÁ¬½ÓµÄ˳Ðò£¬±ÈÈçÎÒÃÇÏë¼ÆËã 2006 ÄêËùÓй«Ë¾µÄÏúÊ۶ÐèÒª¹ØÁª sales ......

SQL Server ErrorLog

תÖÁhttp://mbtk.blog.sohu.com/150003773.html £¬²¢²¹³äһЩÏà¹ØÖªÊ¶¡£
DBCC ErrorLog £ºÈç¹ûºÜÉÙÖØÆðmssqlserver·þÎñ£¬ÄÇô·þÎñÆ÷µÄÈÕÖ¾»áÔö³¤µÃºÜ¿ì£¬¶øÇÒ´ò¿ªºÍ²é¿´ÈÕÖ¾µÄËÙ¶ÈÒ²»áºÜÂý¡£Ê¹ÓÃÕâ¸öÃüÁ¿ÉÒԽضϵ±Ç°µÄ·þÎñÆ÷ÈÕÖ¾£¬Ö÷ÒªÊÇÉú³ÉÒ»¸öеÄÈÕÖ¾¡£¿ÉÒÔ¿¼ÂÇÉèÖÃÒ»¸öµ÷¶ÈÈÎÎñ£¬Ã¿ÖÜÖ´ÐÐÕâ¸öÃüÁî×Ô¶¯½Ø¶Ï·þÎ ......

SQL´¥·¢Æ÷ʵÀý

¶¨Ò壺 ºÎΪ´¥·¢Æ÷£¿ÔÚSQL ServerÀïÃæÒ²¾ÍÊǶÔijһ¸ö±íµÄÒ»¶¨µÄ²Ù×÷£¬´¥·¢Ä³ÖÖÌõ¼þ£¬´Ó¶øÖ´ÐеÄÒ»¶Î³ÌÐò¡£´¥·¢Æ÷ÊÇÒ»¸öÌØÊâµÄ´æ´¢¹ý³Ì¡£
     ³£¼ûµÄ´¥·¢Æ÷ÓÐÈýÖÖ£º·Ö±ðÓ¦ÓÃÓÚInsert , Update , Delete Ê¼þ¡£(SQL Server 2000¶¨ÒåÁËеĴ¥·¢Æ÷£¬Õ ......

JSPÁ¬½ÓSQL SERVER 2008 ÕÒ²»µ½Çý¶¯

ÄÄλ¸ßÊÖÄܰïÎÒ¿´ÏÂΪʲôÅ׳öÕâЩÒì³££¿
´úÂë
<%@ page language="java" import="java.util.*" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="GB2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
< ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ