»òÐíÊÇSqlServer°²×°ÎÊÌâ..... Çó½Ì£¡
SqlServer°²×°µÄ¹ý³ÌÖУ¬ÊDz»ÊÇÓÐÒ»¸öÓòµÄÅäÖ㬷þÎñÆ÷Ãû³ÆÊ¹Óñ¾»ú¼ÆËã»úÃû³Æ£¿
ÊÇÕâÑùµÄ£¬ÓиöÓ¦ÓóÌÐò£¬½øÈëµÄʱºò¾ÍÌáʾ ÕÒ²»µ½·þÎñÆ÷£¬ ÎÒ¿´ÁËÆäËûµÄÅäÖ㬳ýÁËSqlServerµÄ°æ±¾²»Ò»ÑùÍ⣬¾ÍÊÇ·þÎñÆ÷µÄÃû³Æ£¬ÎÒÔÚ°²×°µÄ¹ý³ÌÖÐʹÓõÄÊÇĬÈÏ(local)£¬¶øÁ¬½Ó·þÎñÆ÷µÄÃû³ÆÊDZ¾»úµÄÃû³Æ¡£ÊÔÎÊÈçºÎÄܹ»Ð޸ĸÃSqlµÄ·þÎñÆ÷Ãû³Æ£¿
»¹ÊÇÓÐÆäËûµÄ·½ÃæµÄ´íÎó£¿ Ð»Ð»£¡£¡£¡
Ò»頭霧Ë®£¬幫頂¡£
Â¥Ö÷¸ø³öÊý¾Ý¿âÁ¬½Ó×Ö·û´®»¹ÓзþÎñÆ÷Ãû
ÔÚSQL server°²×°ÖÐÓÐÑ¡ÔñÊDzÉÓÃÓòÓû§»¹ÊDZ¾µØ·½Ê½£¬Ò»°ã¶¼ÊÇÑ¡±¾µØµÄ
ÏÈPING·þÎñÆ÷¿´¿´Äܲ»ÄÜPINGͨ£¬ÔÙ¼ì²éÁ¬½Ó×Ö·û´®£¬ÔÙ²»Ðоͳ¢ÊÔ´ò²¹¶¡£¬ÔÙ²»Ðоͱ¸·ÝÒ»ÏÂÖØ×°Ò»±é¡£
SQL code:
ÅäÖÃÎļþ²»¶Ô...
¿´ÆðÀ´£¬ÄãÊÇ×ö¹ýÀàËÆµÄ²Ù×÷£¬
˵À´ÌýÌý£¬ÅäÖÃÎļþÎÒÒ²×öÁË£¬¾ø¶ÔûÓÐÎÊÌ⣡£¡£
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
´ó¼ÒºÃÏÖÔÚÓÐ Ò»¸öÎÞÏÞ¼¶·ÖÀà±í ÎÒÏë²éѯÈÎÒâÒ»¸ö·ÖÀàÏÂÃæËùÓеÄ×ÓÀࣨÎÞÏÞ¼¶µÄ£©¸ÃÈçºÎʵÏÖÄØ
ÓÃÊ÷Óڽṹ
http://blog.csdn.net/soft_wsx/archive/2009/09/04/4521091.aspx
½á¹¹£¬¼Ç¼
......
1¡£sql2000µÄά»¤¼Æ»®ÔõôÊÖ¶¯Ö´Ðа¡£¬ºÃÏñ²»Ïñ2005ÄǸöÓиö¡°Ö´ÐС±Ñ¡ÏÎÒÏëÏÖÔÚ¾ÍÊÖ¶¯±¸·Ý£¬ÄÇÓ¦¸ÃÔõô×ö²ÅÐÐÄØ
2¡£sql2005Ôõôָ¶¨±¸·ÝÈÕÖ¾ÎļþµÄÈÎÎñÄØ£¬ºÃÏñÔÚ¡°±¸·ÝÊý¾Ý¿âÈÎÎñ¡±ÀïûÓп´µ½
»òÕߣ¬ ......
1¡¢¸÷×Ե͍Ò壺
► nvarchar(n) £º °üº¬ n ¸ö×Ö·ûµÄ¿É±ä³¤¶È Unicode ×Ö·ûÊý¾Ý¡£n µÄÖµ±ØÐë½éÓÚ 1 Óë 4,000 Ö®¼ä¡£×ֽڵĴ洢´óСÊÇËùÊäÈë×Ö·û¸öÊýµÄÁ½±¶¡£ËùÊäÈëµÄÊý¾Ý×Ö·û³¤¶È ......