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

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿

ÈçºÎ½«SqlServerÊý¾Ý¿âÖеÄÊý¾Ýµ¼Èëµ½ExcelÖУ¿
Ñ¡ÔñÊý¾Ý¿â£¬µã»÷ÓÒ¼ü ÈÎÎñ->µ¼³öÊý¾Ý Ö®ºó°´ÕÕÌáʾµ¼³ö¾Í¿ÉÒÔÁË£¡

±í¶àµÄ»° ÓÃÂ¥Éϵķ½·¨ ±È½Ï·½±ã ¿ÉÒÔ°ÑÊý¾Ý¿âÀïÏàÓ¦µÄ±íµ¼³ö »òÕßÈç¹ûÄãÊDzéѯ³öÀ´µÄ½á¹ûµÄ»°  

Äã°ÑÒª¸´ÖƳöÀ´µÄÊý¾ÝÑ¡ÉÏ£¬È»ºóÏÂÒ»²½¾ÍÖ±½Ó¸´ÖƵ½±íÀï ¾Í¿ÉÒÔÁË


Ïà¹ØÎÊ´ð£º

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

sqlserverÖбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈµÄº¬Òå

sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É

identity?ɶÒâ˼£¿

IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......

ÇóJAVAÖ´Ðе¼³öSQLSERVERÊý¾Ý¿â±¸·Ý·½·¨

ÐèÇó˵Ã÷£º
ÔÚJSPǰִ̨ÐÐÒ»¸ö²Ù×÷£¬±¸·ÝºÃºǫ́SQLSERVERÊý¾Ý¿â±¸·Ý¡£
Çë¸÷λ´óϺ¸ø½éÉÜһϽâ¾ö·½°¸¡£
ǰ̨µ÷Óúǫ́µÄÒ»¸ö´æ´¢¹ý³Ì¾Í¿ÉÒÔÁË¡£

²»ÖªµÀ´æ´¢¹ý³ÌÔõÃ´Ð´ÄØ£¿»¹ÇëÏ£ÍûÌṩһ¸ö·¶Àý¡£¸Ðл£¡



......

JDBCÁ¬½Ómicrosoft sqlserverÒªÔõôÁ¬°¡

ŪÁ˰ëÌì¶¼»¹ÊÇŪ²»ºÃ£¬ÔÚÓÃmyeclipse¿ª·¢ÖÐÒªÔõÃ´ÅªÄØ£¬
Ï£Íû˵˵¾ßÌå²½Öè

Ê×ÏÈÓ¦¸Ã°ÑÒì³£·ÅÉÏÀ´

Ò»°ãÈç¹ûÊÇÔÚXPϵͳÏÂ,×°ÉÏSP3»òSP4,´ò¿ª1433¶Ë¿Ú.....

netstat -an¿ÉÒԲ鿴ÊÇ·ñ´ò¿ªÁË1433¶ ......

SQLServer IP¿â ²éѯIP²»Í¬ ËÙ¶ÈÏà²î¾Þ´ó ÇóÓÅ»¯Òâ¼û

ÕâÀïÑ¡ÓÃÁË´¿ÕæQQ IP¿â
°´ÕÕ´«Í³µÄ·½·¨ IPתΪdecimal
±ÈÈç
IP±í

IPStart      IPEnd      Address
-------------------------------------
994304000  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ