¹ØÓÚSQL Server2005µÄÎÊÌâ
ÇëÎÊÒ»ÏÂÔÚSQL Server2005 Ï£¬ ÔÊÐí¶à¸ö½ø³ÌͬʱÐÞ¸ÄÒ»¸ö±íÂ𣿠ÎÒÊÇ2¸ö½ø³Ì¶¼Òª¸üÐÂij¸ö±í£¬ºÃÏñÎÒÏÖÔÚÕâÑù²Ù×÷»áÈÃÊý¾Ý¿âËÀËøÁË£¬ Èç¹û²»ÄÜͬʱ²Ù×÷£¬ÄÇÎÒÓ¦¸ÃÈçºÎÐÞ¸ÄÄØ£¿»òÕß˵ÄÄÀïÓÐÉèÖÃʹµÃ¿ÉÒÔͬʱ²Ù×÷Â𣿠¸úËøÓйØÏµÂð
Èç¹ûÖ»Êǵ¥Ò»µÄÒ»¸öupdate±í ²»»áËÀËøÒýÓà Èç¹ûÖ»Êǵ¥Ò»µÄÒ»¸öupdate±í ²»»áËÀËø ÄãºÃ£¬ÎÊÌâÊÇÎÒÏÖÔÚÊÇ2¸ö³ÌÐò updateͬһ¸ö±íÄØ¡£¡£ ÇëÎÊÓа취Âð ²¢·¢²Ù×÷ÊÇÊý¾Ý¿âϵͳһ¸öÖØÒªÌØÕ÷£¬ËùÒÔ²»Òª¶ã±Ü²¢·¢ ¶Ô²¢·¢²Ù×÷µÄ´¦Àí¿Ï¶¨Éæ¼°Ëø£¬Ñ¡ÔñºÏÊʵÄËøÐÐΪÀ´´ïµ½ÎÒÃǵÄÒªÇóÊÇÎÒÃÇÐèÒª¿¼Âǵġ£ ²¢·¢²Ù×÷ÊÇÊý¾Ý¿âϵͳһ¸öÖØÒªÌØÕ÷£¬ËùÒÔ²»Òª¶ã±Ü²¢·¢ ¶Ô²¢·¢²Ù×÷µÄ´¦Àí¿Ï¶¨Éæ¼°Ëø£¬Ñ¡ÔñºÏÊʵÄËøÐÐΪÀ´´ïµ½ÎÒÃǵÄÒªÇóÊÇÎÒÃÇÐèÒª¿¼Âǵġ£ ÒýÓà ²¢·¢²Ù×÷ÊÇÊý¾Ý¿âϵͳһ¸öÖØÒªÌØÕ÷£¬ËùÒÔ²»Òª¶ã±Ü²¢·¢ ¶Ô²¢·¢²Ù×÷µÄ´¦Àí¿Ï¶¨Éæ¼°Ëø£¬Ñ¡ÔñºÏÊʵÄËøÐÐΪÀ´´ïµ½ÎÒÃǵÄÒªÇóÊÇÎÒÃÇÐèÒª¿¼Âǵġ£ ÇëÎÊÄܾٸöÀý×ÓÂð£¿ ËøµÄÀý×Ó£¬ ÎÒ»¹²»Ì«»á°¡ÒýÓà ÇëÎÊÒ»ÏÂÔÚSQL Server2005 Ï£¬ ÔÊÐí¶à¸ö½ø³ÌͬʱÐÞ¸ÄÒ»¸ö±íÂ𣿠ÎÒÊÇ2¸ö½ø³Ì¶¼Òª¸üÐÂij¸ö±í£¬ºÃÏñÎÒÏÖÔÚÕâÑù²Ù×÷»áÈÃÊý¾Ý¿âËÀËøÁË£¬ Èç¹û²»ÄÜͬʱ²Ù×÷£¬ÄÇÎÒÓ¦¸ÃÈçºÎÐÞ¸ÄÄØ£¿»òÕß˵ÄÄÀïÓÐÉèÖÃʹµÃ¿ÉÒÔͬʱ²Ù×÷Â𣿠¸úËøÓйØÏµÂð ÀíÂÛÉϲ»´æÔÚͬʱ¸ÄµÄ×´¿ö£¬¶¼Êǰ´ÕÕÒ»¶¨Ë³ÐòÐ޸ĵġ£ËùÒÔ²ÅÓÐÁËËøµÄ´¦Àí·½Ê½¡£ ÈçºÎÐ޸ĵϰ£¬»¹µÃ¿´ÒµÎñÒªÇó¡£ ÒýÓÃ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ' select cast(convert(numeric(18,2),1275674000000/100000000)as real) ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿ MySQL 5.1²Î¿¼ÊÖ²á ÒýÓà ÐÖµÜÄã»á½áÌùÂ𣿠mysql ²Î¿¼ÊÖ²á baidu MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......