SqlServer×¢²áµÄÎÊÌâ
ÎÒн¨SqlServer×¢²á-¡·ÏÂÒ»²½-¡·Ñ¡ÔñÒ»¸öSql Server ÀïÃæ ÏÂÃæ×ó±ßÄǸöÁбí¿ò¿ÉÓ÷þÎñÆ÷ÀïÃæÊ²Ã´Ò²Ã»ÓÐ ÎҲŽӴ¥Õâ¸ö ´ËʱºÍÊéÉÏдµÄÍêÈ«²»Í¬ Òò´ËÎÒËæ±ãÌî¸öÃû×ÖÉÏÈ¥ È»ºóÏÂÒ»²½ ÕâÑù×îºóµÄ½á¹ûÊÇSqlServer²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø Õâ¸öÊDZíʾÎÒÕâ¸öSql2000ÆóÒµ°æÔÚXPϰ²×°µÃ²»¶Ôô
»¹ÓÐÒ»¸öÎÊÌâ¾ÍÊÇËûÃÇ˵µÄ1433¶Ë¿ÚÎÒÕâ±ß¶¼Ã»Óдò¿ªÆð Âé·³´ó¼ÒÖ¸µ¼ÏÂ
Ñ¡ÔñÒ»¸öSql Server ÀïÃæ ÏÂÃæ×ó±ßÄǸöÁбí¿ò¿ÉÓ÷þÎñÆ÷ÀïÃæÊ²Ã´Ò²Ã»ÓÐ ÎҲŽӴ¥Õâ¸ö ´ËʱºÍÊéÉÏдµÄÍêÈ«²»Í¬ Òò´ËÎÒËæ±ãÌî¸öÃû×ÖÉÏÈ¥
--Ìîsqlserver·þÎñÆ÷µÄIPµØÖ·»ò»úÆ÷Ãû
ÎÒÌîÁËÎÒ×Ô¼ºµÄ»úÆ÷Ãû ½á¹ûËû˵Õâ¸ö·þÎñÒѾÔÚÔËÐÐÁË ÎÒ×Ô¼ºÕâ¸ö·þÎñµÄIPµØÖ·ÊǶàÉÙ ÎÒÔõô²é¿´£¿£¿£¿ ¶øÇÒÕâ¸ö×¢²áʱ¸ÉʲôÓÃµÄ Ê²Ã´½Ð×öÔ¶³Ì·þÎñÆ÷ ÎÒÕâ¸ö×Ô¼º×°µÄ»úÆ÷Ò²½ÐÔ¶³Ìô£¿£¿ ÎÒÖªµÀÕâ¸öÎÊÌâºÜSB µ«ÊÇÂé·³´ó¸ç°ïÎÒÄÍÐĽâÊÍÏÂ
OKÁË Ð»Ð» µ«ÊÇÎÒÕâ¸öSqlServer×éÀïÃæÓÐÁ½¸ö Ò»¸öÊÇ£¨local£© Ò»¸öÊÇ192.168.1.101 ÕâÁ½¸ö·þÎñÆ÷ÊÇÒ»ÑùµÄô£¿ ÓÐÊ²Ã´Çø±ð£¿
ÔÚÄǸöÀïÃæÌîÁËÎÒ×Ô¼ºµÄ»úÆ÷Ãû ×¢²á½á¹ûËû˵Õâ¸ö·þÎñÒѾÔÚÔËÐÐÁË Õâ¸öÌîÈë×Ô¼º¼ÆËã»úÃû×ÖµÄÄǸö·þÎñÆ÷¾ÍÊÇÇ°ÃæµÄÄǸölocalô£¿
Ò»ÑùµÄ¶¼ÊÇÖ¸ÏòÄã×Ô¼º
²»¹ýÊÇMSSQLÌṩµÄÁ¬½Ó·½·¨²»Í¬£¬µ«ÊÇÖ¸ÏòµÄÄ¿±êÏÔÈ»ÊÇÒ»¸ö
²Î¿¼£º
http://school.itzcn.com/special-spid-48.html
ÉÏÃæ½²½âµÄ±È½ÏÏêϸ£¬Ï£Íû¶ÔÂ¥Ö÷ÓÐËù°ïÖú¡£
{{----
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
Êý¾ÝÒÔ´óÎļþµÄ·½Ê½£¬´æÔÚÊý¾Ý¿âÖС£Îļþ´óС²»Ò»Ö£¬Óм¸°ÙKµÄ£¬Ò²ÓÐ1G¶àµÄ¡£Îļþ¸ñʽ²»Í³Ò»£¬ÓÐZIP£¬RAR£¬DWG£¬WPSµÈµÈ¡£
ÏÖÔÚÏë°Ñ´óÎļþµ¼³öµ½¾ÖÓòÍøÄÚµÄһ̨µçÄԵĹ²ÏíÎļþ¼ÐÄÚ£¨ÎÞSQL SERVER£¬ÓÐÓû§Ãû¼ ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÔÚÊý¾Ý¿âÖÐÈÕÆÚÈçÏÂÏÔʾ£º2009-2-27 9:40:47
Õâ¸ö²»ÊÇÎÒÏëÒªµÄ£¬ÎÒÐèÒªÔ·ݺÍʱ¼äÓÃÁ½Î»Êý±íʾ£¬ÉÏÃæµÄÓ¦¸Ãת»»Îª;2009-02-27 09:40:47
ÇëÎÊ
1¡¢ÈçºÎ¶ÔÏÖÓÐÈÕÆÚ½øÐÐת»»£¨Êý¾Ý¿âÖÐÒÑ´æÔÚÐí¶àÀàËÆµÄÖµ£¬ÎÒÐèÒª½«Æä ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......