sql server ÀàÐÍ JDBC ÀàÐÍ (java.sql.Types) Java ÓïÑÔÀàÐÍ bigint BIGINT long timestamp binary BINARY byte[] bit BIT boolean char nchar CHAR String decimal money smallmoney DECIMAL java.math.BigDecimal float DOUBLE double int INTEGER int image LONGVARBINARY byte[] text ntext LONGVARCHAR String numeric NUMERIC java.math.BigDecimal real REAL float smallint SMALLINT short datetime smalldatetime TIMESTA...
by wangcunjiang - Java - 2008-09-04 15:08:21 ÔĶÁ£¨2960£© »Ø¸´£¨3£©
·ÖÏíASP.NETÊÓÆµÏµÁн̡̳ª¡ªµÚ¾Å½² sql server 2005ÖнøÐбíºÍÊý¾ÝµÄ²Ù×÷ Ö÷Òª½²½âÁËÈçºÎÔÚsql server 2005ÖнøÐбíºÍÊý¾ÝµÄ²Ù×÷¡£µÚ¾Å½ÚµÄÊÓÆµ½Ì³ÌÏêϸµÄ½²½âÁËÔÚsql server¹ÜÀí¹¤¾ßÖнøÐÐÊý¾ÝµÄÔö£¬É¾£¬²é£¬¸ÄµÈ²Ù×÷£¬²¢ÇÒ½²½âÁËÈçºÎ´´½¨Êý¾Ý¿â£¬´´½¨Êý¾Ý±í£¬Ð޸ıíÄÚÈÝ£¬Ð½¨²éѯµÈÄÚÈÝ£¬¿ÉÒÔÈöÁÕßÔÚÕâÒ»½ÚµÄÊÓÆµÖÐÉîÈëÁ˽âsql serverµÄʹÓᣠ¹Û¿´ÊÓÆµ Èç¹û´ó¼ÒÔÚÓÅ¿áÍøÉÏ¿´µÄ²»Çå³þ£¬¿ÉÒÔÖ±½Ó µã»÷ÕâÀï È¥ÏÂÔØ....
¡¡¡¡¶ÔÓÚ¹ØÏµÐÍÊý¾Ý¿âÀ´Ëµ£¬±íÏÖÊ÷×´µÄ²ã´Î½á¹¹Ê¼ÖÕÊÇÒ»¸öÎÊÌ⡣΢ÈíÔÚsql server 2005ÖÐÊ״γ¢ÊÔÁ˽â¾öÕâ¸öÎÊÌ⣬ÄǾÍÊDZ»³ÆÖ®ÎªÍ¨ÓÃÊý¾Ý±í±í´ïʽ£¨Common Table Expressions£¬CTE£©µÄʵÏÖ·½Ê½¡£ ¡¡¡¡¾¡¹ÜCTEÔÚÏÖÓеÄÊý¾Ý¿â¼Ü¹¹ÖÐÔËÐÐÁ¼ºÃ£¬Î¢ÈíÕÒµ½ÁËÒ»ÖÖ½«´ËÀà²ã´Î½á¹¹×÷ΪͷµÈ¸ÅÄîÀ´Ê¹Óõķ½Ê½¡£Òò´ËΪÁËʵÏÖÕâÖÖЧ¹û£¬ËûÃÇÔÚsql server 2008ÖÐÌá³öÁËÒ»ÖÖ¡°HierarchId¡±Êý¾ÝÀàÐÍ¡£ ¡¡¡¡ÔÚ´«Í³µÄ²ã´Î½á¹¹ÖУ¬Ò»Ìõ¼Ç¼½ö½ö´¢´æ...
²ì¿´±¾ÎÄÓ¦ÓÃÓڵIJúÆ· ÎÄÕ±àºÅ : 139444 ×îºóÐÞ¸Ä : 2006Äê3ÔÂ3ÈÕ ÐÞ¶© : 4.0 ¸ÅÒª Microsoft sql server ±í²»Ó¦¸Ã°üº¬Öظ´ÐкͷÇΨһÖ÷¼ü¡£Îª¼ò½àÆð¼û£¬ÔÚ±¾ÎÄÖÐÎÒÃÇÓÐʱ³ÆÖ÷¼üΪ¡°¼ü¡±»ò¡°PK¡±£¬µ«ÕâʼÖÕ±íʾ¡°Ö÷¼ü¡±¡£Öظ´µÄ PK Î¥·´ÁËʵÌåÍêÕûÐÔ£¬ÔÚ¹ØÏµÏµÍ³ÖÐÊDz»ÔÊÐíµÄ¡£sql server Óи÷ÖÖÇ¿ÖÆÖ´ÐÐʵÌåÍêÕûÐԵĻúÖÆ£¬°üÀ¨Ë÷Òý¡¢Î¨Ò»Ô¼Êø¡¢Ö÷¼üÔ¼ÊøºÍ´¥·¢Æ÷¡£ ¾¡¹ÜÈç´Ë£¬ÔÚijЩÇé¿öÏ»¹¿ÉÄÜ»á³öÏÖÖØ¸´µÄÖ÷¼ü£»Èç¹û³öÏÖ´ËÀà...
sql serverÓ¦¸ÃÔõÑù·ÃÎÊsybaseÊý¾Ý¿âµÄ±í£¿ ¾ßÌå²½ÖèÈçÏ£º 1: °²×°sybase¿Í»§¶Ë °æ±¾µÄÒªÇó: Sybase Client 11.9.2 for NT 1.1:°²×°Íê³Éºó,ÔËÐпªÊ¼-£¾³ÌÐò-£¾sybase-£¾Dsedit 1.2:Ñ¡Ôñ²Ëµ¥µÄ'server Object',-£¾ 'Add' ÊäÈë·þÎñÃû ±ÈÈç 1.70 1.3:È»ºóÔÚserverÁбíÖÐÑ¡Ôñ'1.70',Ë«»÷ÓұߵĶԻ°¿òserver addressÀ¸,ÔÚNetwork Address Attribute¶Ô»°¿òÖÐ Ñ¡Ôñadd ÌîÈëipµØÖ·,±ÈÈç132.228.1.70,4300,...
¹ØÓÚsql server 2005Ç¨ÒÆµ½MYsql 5ÖÐÎÄÂÒÂëÇë½Ì ÎÒÏë°Ñsql server 2005ÏÂÃæµÄÒ»¸ö¿âAA£¬Ç¨µ½MYsql 5Êý¾Ý¿âÉÏ£¬ÎÒÓÃMYsql MIGRATION TOOKITÀ´½øÐÐÇ¨ÒÆ²Ù×÷£¬¿ÉÊǵ½±íÖÐÓÐÖÐÎÄʱ£¬µ½MYsqlÀï¶¼ÊÇÂÒÂ룬ÇëÎʸÃÔõô½â¾öÕâ¸öÂÒÂëÎÊÌ⣬¶àлÁË£¡£¡
×öΪϵͳ ´æ´¢¹ý³Ì £¬sp_lock¿ÉÒÔÓÃÀ´Á˽⠷þÎñÆ÷ µÄÔËÐÐÇé¿ö£¬Í¨¹ý²é¿´ÏµÍ³µÄËø¶¨ÐÅÏ¢Õï¶Ï sql server ¿ÉÄܳöÏÖµÄÎÊÌâ¡£²»¹ýϵͳ´æ´¢¹ý³Ìsp_lock±¾Éí´æÔÚһЩȱÏÝ¡£ ¶ÔÓÚ Êý¾Ý¿â¹ÜÀí ÐÂÊÖÀ´Ëµ£¬Æä·µ»ØµÄ½á¹û²»¹»Ö±°×£¬»¨·ÑÁË´óÁ¿µÄ¹¤×÷À´ÏÔʾϵͳÖÐÄĸö»á»°Ôì³ÉÁË×î¶àËø¶¨£¬È´²¢Ã»ÓÐÌṩ¶àÉÙ¹ØÓÚÕâЩ¶ÔÏó»ò»á»°µÄÏàÓ¦ÏêϸÐÅÏ¢¡£ËäÈ»ÎÒÃÇ¿ÉÒÔ´´½¨×Ô¶¨ÒåµÄ½Å±¾À´²é¿´ÕâЩÐÅÏ¢£¬µ«ÊÇ·µ»ØµÄ½á¹ûÍùÍù¹ýÓÚ¸´ÔÓ£¬¶ø³äÆäÁ¿ÄÜ·µ»ØÒ»...
ÏÖÔںܶàÍøÕ¾¶¼ÌṩÁËÕ¾ÄÚµÄËÑË÷¹¦ÄÜ£¬Óеĺܼòµ¥ÔÚsqlÓï¾äÀï¼ÓÒ»¸öÌõ¼þÈ磺where names like ¡®%words%¡¯¾Í¿ÉÒÔʵÏÖ×î»ù±¾µÄËÑË÷ÁË¡£ ÎÒÃÇÀ´¿´¿´¹¦ÄÜÇ¿´óÒ»µã£¬¸´ÔÓÒ»µãµÄËÑË÷ÊÇÈçºÎʵÏֵģ¨ÔÚsql¡¡£Ó£Å£Ò£Ö£Å£Ò£²£°£°£¯£²£°£°£µÍ¨¹ý ´æ´¢¹ý³Ì ʵÏÖËÑË÷Ëã·¨£©¡£ ÎÒÃǰÑÓû§µÄËÑË÷¿ÉÒÔ·ÖΪÒÔÏÂÁ½ÖÖ£º 1.¾«È·ËÑË÷,¾ÍÊǰÑÓû§ÊäÈëµÄ¸÷¸ö´ÊÓïµ±³ÉÒ»¸öÕûÌå,²»·Ö¸îËÑË÷. 2.Ïñ°Ù¶È,GOOGLEÒ»ÑùµÄ,°´¿Õ¸ñ°ÑÊäÈëµÄÿһ¸ö´Ê·ÖÀë...
ÎÒʹÓÃbit varyingÀàÐÍʱ£¬ÔÚjavaÖÐʹÓÃrs.getBytesʱµÄ²»µ½ÏàÓ¦µÄbyteÊý×飬Ӧ¸ÃÊǵõ½8λµÄÊý×飬½á¹ûµÃµ½ÁË64λ£¬Ã¿¸ö1£¬0¶¼±ä³ÉÁËÒ»¸öÊý×飿£¡Ôõô²ÅÄܵõ½ºÍsqlÒ»ÑùµÄ8λÊý×éÄÇÑùµÄЧ¹û¡£Çë´óÏÀÖ¸½Ì
Èç¹ûÊÇsql serverÖеÄTEXT×Ö¶ÎÀàÐÍ£¬ÄÇôÔÚMYsql 5ÖиÃÓÃʲô×Ö¶ÎÀàÐÍÓëÖ®¶ÔÓ¦²ÅÄܰÑTEXTÖеÄÊý¾ÝǨµ½MYsql 5ÖУ¿