ajaxÖÐXMLHttpRequest²ÎÊýÏê½â ÊÕ²Ø
XJAX ,²¢²»ÊÇÒ»ÖÖÐÂ[url=javascript:;]¼¼Êõ[/url]µÄµ®Éú.Ëüʵ¼ÊÉÏ´ú±íµÄÊǼ¸Ïî¼¼Êõ°´Ò»¶¨µÄ·½Ê½×éºÏÔÚÒ»ÔÚͬ¹²µÄÐ×÷Öз¢»Ó¸÷×ÔµÄ×÷ÓÃ.
Ëü°üÀ¨£º
ʹÓÃXHTMLºÍ[url=javascript:;]CSS[/url]±ê×¼»¯³ÊÏÖ£»
ʹÓÃDOMʵÏÖ¶¯Ì¬ÏÔʾºÍ½»»¥£»
ʹÓÃ[url=javascript:;]XML[/url]ºÍXSLT½øÐÐÊý¾Ý½»»»Óë´¦Àí£»
ʹÓÃXMLHttpRequest½øÐÐÒì²½Êý¾Ý¶ÁÈ¡£»
×îºóÓÃJavaScript°ó¶¨ºÍ´¦ÀíËùÓÐÊý¾Ý¡£
ÔÚÕâÀïÎÒÖ»Ïò̸µãXMLHttpRequest¶ÔÏó:
ÔÚÉÏÃæ¿´µ½,ʹÓÃXMLHttpRequest½øÐÐÒì²½Êý¾Ý¶ÁÈ¡£»
Ê×ÏÈ,ÎÒÃÇÒª´´½¨¸Ã[url=javascript:;]¶ÔÏó[/url],Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷,¸Ã¶ÔÏóµÄ´´½¨[url=javascript:;]·½·¨[/url]ÊÇÓÐÇø±ð.
[url=javascript:;]Internet[/url] ExplorerÒÔActiveX¶ÔÏóÒýÈë,±»³ÆÎªXMLHTTP.
¶ÔÓÚInternet Explorerä¯ÀÀÆ÷£¬´´½¨XMLHttpRequest ·½·¨ÈçÏ£º
xmlhttp_request = new ActiveXObject("Msxml2.XMLHTTP.3.0"); //3.0»ò4.0, 5.0
xmlhttp_request = new ActiveXObject("Msxml2.XMLHTTP");
xmlhttp_request = new ActiveXObject("Microsoft.XMLHTTP");
ÔÚ²»Í¬Internet Explorerä¯ÀÀÆ÷ÖÐXMLHTTP°æ±¾¿ÉÄܲ»Ò»Ö£¬ÎªÁ˸üºÃµÄ¼æÈݲ»Í¬°æ±¾µÄInt ......
×î½ü×Ô¼ºÊµÏÖÁËÒ»¸öwapä¯ÀÀÆ÷£¬³õÖÔʹÓÃÀ´×öÊý¾Ý²É¼¯µÄ£¬ÆäʵÓÃÀ´×öÍøÒ³ä¯ÀÀ¿´À´Ò²¿ÉÒÔ£¬²»¹ýj2meÉÏ»ù±¾¶¼²»Ö§³ÖgifͼƬ°¡£¬ËùÒÔÓÐЩͼƬ²»ÄÜÏÔʾ£¬»¹ÓоÍÊÇpostºº×ÖµÄʱºò·þÎñÆ÷»áÈÏΪÊÇÂÒÂë¡£
ÏÂÃæÊÇһЩ½ØÍ¼:
ĿǰµÄÖÐÎÄÊäÈë·¨²»ºÃÓ㬵ÈÓпÕÁËÔÙ°ÑÎÄ×Ö°´Ê¹ÓÃÆµÂÊÅÅÐò£¬ÓÐÐËȤµÄÅóÓÑ¿ÉÒÔÒ»Æð̽ÌÖ°¡£º£©
mail:qiangpenggg@gmail.com ......
SQL Server ÌṩϵͳÊý¾ÝÀàÐͼ¯£¬¶¨ÒåÁË¿ÉÓë SQL Server Ò»ÆðʹÓõÄËùÓÐÊý¾ÝÀàÐÍ¡£ÏÂÃæÁгöϵͳÌṩµÄÊý¾ÝÀàÐͼ¯¡£
¿ÉÒÔ¶¨ÒåÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ£¬ÆäÊÇϵͳÌṩµÄÊý¾ÝÀàÐ͵ıðÃû¡£ÓйØÓû§¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸü¶àÐÅÏ¢£¬Çë²Î¼û sp_addtype ºÍ´´½¨Óû§¶¨ÒåµÄÊý¾ÝÀàÐÍ¡£
µ±Á½¸ö¾ßÓв»Í¬Êý¾ÝÀàÐÍ¡¢ÅÅÐò¹æÔò¡¢¾«¶È¡¢Ð¡ÊýλÊý»ò³¤¶ÈµÄ±í´ïʽͨ¹ýÔËËã·û½øÐÐ×éºÏʱ£º
ͨ¹ý½«Êý¾ÝÀàÐ͵ÄÓÅÏÈ˳Ðò¹æÔòÓ¦Óõ½ÊäÈë±í´ïʽµÄÊý¾ÝÀàÐÍÀ´È·¶¨ËùµÃÖµµÄÊý¾ÝÀàÐÍ¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼ûÊý¾ÝÀàÐ͵ÄÓÅÏÈ˳Ðò¡£
Èç¹û½á¹ûÊý¾ÝÀàÐÍΪ char¡¢varchar¡¢text¡¢nchar¡¢nvarchar »ò ntext£¬Ôò½á¹ûÖµµÄÅÅÐò¹æÔòÓÉÅÅÐò¹æÔòµÄÓÅÏÈ˳Ðò¹æÔò¾ö¶¨¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼ûÅÅÐò¹æÔòµÄÓÅÏÈ˳Ðò¡£
½á¹ûµÄ¾«¶È¡¢Ð¡ÊýλÊý¼°³¤¶ÈÈ¡¾öÓÚÊäÈë±í´ïʽµÄ¾«¶È¡¢Ð¡ÊýλÊý¼°³¤¶È¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼û¾«¶È¡¢Ð¡ÊýλÊýºÍ³¤¶È¡£
SQL Server Ϊ SQL-92 ¼æÈÝÐÔÌṩÁËÊý¾ÝÀàÐÍͬÒå´Ê¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼ûÊý¾ÝÀàÐÍͬÒå´Ê¡£
¾«È·Êý×Ö
ÕûÊý
bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,64 ......
Êý¾ÝÀàÐÍ
ÀàÐÍ
ÃèÊö
bit
ÕûÐÍ
bit Êý¾ÝÀàÐÍÊÇÕûÐÍ£¬ÆäÖµÖ»ÄÜÊÇ0¡¢1»ò¿ÕÖµ¡£ÕâÖÖÊý¾ÝÀàÐÍÓÃÓÚ´æ´¢Ö»ÓÐÁ½ÖÖ¿ÉÄÜÖµµÄÊý¾Ý £¬ÈçYes »òNo¡¢True »òFa lse ¡¢On »òOff
int
ÕûÐÍ
int Êý¾ÝÀàÐÍ¿ÉÒÔ´æ´¢´Ó- 231(-2147483648)µ½231 (2147483 647)Ö®¼äµÄÕûÊý¡£´æ´¢µ½Êý ¾Ý¿âµÄ¼¸ºõËùÓÐÊýÖµÐ͵ÄÊý¾Ý¶¼¿ÉÒÔÓÃÕâÖÖÊý¾ÝÀàÐÍ¡£ÕâÖÖÊý¾ÝÀàÐÍÔÚÊý¾Ý¿âÀïÕ¼ÓÃ4¸ö ×Ö½Ú
smallint
ÕûÐÍ
smallint Êý¾ÝÀàÐÍ¿ÉÒÔ´æ´¢´Ó- 215(-32768)µ½ 215(32767)Ö®¼äµÄÕûÊý¡£ÕâÖÖÊý¾ÝÀàÐͶԴ洢һЩ³£ÏÞ¶¨ÔÚÌØ¶¨·¶Î§ÄÚµÄÊý ÖµÐÍÊý¾Ý·Ç³£ÓÐÓá£ÕâÖÖÊý¾ÝÀàÐÍÔÚÊý¾Ý¿âÀïÕ¼ÓÃ2 ×Ö½Ú¿Õ¼ä
tinyint
ÕûÐÍ
tinyint Êý¾ÝÀàÐÍÄÜ´æ´¢´Ó0µ½255 Ö®¼äµÄÕûÊý¡£ËüÔÚÄãÖ»´òËã´æ´¢ÓÐÏÞÊýÄ¿µÄÊýÖµ ʱºÜÓÐÓᣠÕâÖÖÊý¾ÝÀàÐÍÔÚÊý¾Ý¿âÖÐÕ¼ÓÃ1 ¸ö×Ö½Ú
numeric
¾«È·Êý ÖµÐÍ
numericÊý¾ÝÀàÐÍÓëdecimal ÐÍÏàͬ
decimal
¾«È·ÊýÖµÐÍ
decimal Êý¾ÝÀàÐÍÄÜÓÃÀ´´æ´¢´Ó-1038-1µ½ 1038-1µÄ¹Ì¶¨¾«¶ÈºÍ·¶Î§µÄÊýÖµÐÍÊý¾Ý¡£Ê¹ÓÃÕâÖÖÊý¾ÝÀàÐÍʱ£¬±ØÐëÖ¸ ......
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
¡¡¡¡SQL·ÖÀࣺ
¡¡¡¡DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
¡¡¡¡DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
¡¡¡¡DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
¡¡¡¡Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
¡¡¡¡1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
¡¡¡¡2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
¡¡¡¡3¡¢ËµÃ÷£º±¸·Ýsql server
¡¡¡¡--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
¡¡¡¡--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
¡¡¡¡4¡¢ËµÃ÷£º´´½¨Ð±í
create table tabname(col1 type1 [not null] [primary key],col2 type2 [not null],..)
¡¡¡¡¸ù¾ÝÒÑÓÐµÄ±í´´½¨ÐÂ±í£º
A£ºcreate table tab_new like tab_old (ʹÓÃ¾É±í´´½¨Ð±í)
B£ºcreate table tab_new as select col1,col2… from tab_old definition only
¡¡¡¡5¡¢ËµÃ÷£º
¡¡¡¡É¾³ýÐÂ±í£ºdrop table tabname
¡¡¡¡6¡¢ËµÃ÷£º
¡¡¡¡Ôö¼ÓÒ»¸öÁУºAlter table tabname add column col type
¡¡¡¡×¢£ºÁÐÔö¼Óºó½«²»ÄÜɾ³ý¡ ......
×¢£º´Ëº¯ÊýÊÇÔÚÍøÉÏËÑË÷µÃÀ´£¬Òò´ËÎÞ·¨×¢Ã÷×÷ÕßÃû£¬Äª¹Öι֡£ºÙ¡£
/// <summary>
/// °´×Ö½Ú³¤¶È½ØÈ¡×Ö·û´®(Ö§³Ö½ØÈ¡´øHTML´úÂëÑùʽµÄ×Ö·û´®)
/// </summary>
/// <param name="content">½«Òª½ØÈ¡µÄ×Ö·û´®²ÎÊý</param>
/// <param name="length">½ØÈ¡µÄ×Ö½Ú³¤¶È</param>
/// <param name="StripHTML">½ØÈ¡µÄ½á¹ûÊÇ·ñΪhtml´úÂë</param>
/// <returns>½ØÈ¡µÄ×Ö·û´®</returns>
public static string GetContentSummary(string content, int length, bool StripHTML)
{
if (string.IsNullOrEmpty(content) || length == 0)
return "";
if (StripHTML)
{
System.Text.RegularExpressions.Regex re = new System.Text.RegularExpressions.Regex("<[^>]*>");
content = re.Replace(content, "");
content = content.Replace("¡¡", "").Replace(" ", "").Replace(" ", "");
if (conten ......
×¢£º´Ëº¯ÊýÊÇÔÚÍøÉÏËÑË÷µÃÀ´£¬Òò´ËÎÞ·¨×¢Ã÷×÷ÕßÃû£¬Äª¹Öι֡£ºÙ¡£
/// <summary>
/// °´×Ö½Ú³¤¶È½ØÈ¡×Ö·û´®(Ö§³Ö½ØÈ¡´øHTML´úÂëÑùʽµÄ×Ö·û´®)
/// </summary>
/// <param name="content">½«Òª½ØÈ¡µÄ×Ö·û´®²ÎÊý</param>
/// <param name="length">½ØÈ¡µÄ×Ö½Ú³¤¶È</param>
/// <param name="StripHTML">½ØÈ¡µÄ½á¹ûÊÇ·ñΪhtml´úÂë</param>
/// <returns>½ØÈ¡µÄ×Ö·û´®</returns>
public static string GetContentSummary(string content, int length, bool StripHTML)
{
if (string.IsNullOrEmpty(content) || length == 0)
return "";
if (StripHTML)
{
System.Text.RegularExpressions.Regex re = new System.Text.RegularExpressions.Regex("<[^>]*>");
content = re.Replace(content, "");
content = content.Replace("¡¡", "").Replace(" ", "").Replace(" ", "");
if (conten ......