ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡
±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ½á¹ûµÄ»°
Äã°ÑÒª¸´ÖƳöÀ´µÄÊý¾ÝÑ¡ÉÏ£¬È»ºóÏÂÒ»²½¾ÍÖ±½Ó¸´ÖƵ½±íÀï ¾Í¿ÉÒÔÁË
Ïà¹ØÎÊ´ð£º
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
ÐèÇó˵Ã÷£º
ÔÚJSPǰִ̨ÐÐÒ»¸ö²Ù×÷£¬±¸·ÝºÃºǫ́SQLSERVERÊý¾Ý¿â±¸·Ý¡£
Çë¸÷λ´óϺ¸ø½éÉÜһϽâ¾ö·½°¸¡£
ǰ̨µ÷Óúǫ́µÄÒ»¸ö´æ´¢¹ý³Ì¾Í¿ÉÒÔÁË¡£
²»ÖªµÀ´æ´¢¹ý³ÌÔõÃ´Ð´ÄØ£¿»¹ÇëÏ£ÍûÌṩһ¸ö·¶Àý¡£¸Ðл£¡
......
ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè
Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´
Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....
netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶ ......
ÕâÀïÑ¡ÓÃÁË´¿ÕæQQ IP¿â
°´ÕÕ´«Í³µÄ·½·¨ IPתΪdecimal
±ÈÈç
IP±í
IPStart IPEnd Address
-------------------------------------
994304000  ......