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

¹ØÓÚSQL Server2005µÄÎÊÌâ

ÇëÎÊÒ»ÏÂÔÚSQL Server2005 Ï£¬ ÔÊÐí¶à¸ö½ø³ÌͬʱÐÞ¸ÄÒ»¸ö±íÂð£¿

ÎÒÊÇ2¸ö½ø³Ì¶¼Òª¸üÐÂij¸ö±í£¬ºÃÏñÎÒÏÖÔÚÕâÑù²Ù×÷»áÈÃÊý¾Ý¿âËÀËøÁË£¬

Èç¹û²»ÄÜͬʱ²Ù×÷£¬ÄÇÎÒÓ¦¸ÃÈçºÎÐÞ¸ÄÄØ£¿»òÕß˵ÄÄÀïÓÐÉèÖÃʹµÃ¿ÉÒÔͬʱ²Ù×÷Âð£¿

¸úËøÓйØÏµÂð
Èç¹ûÖ»Êǵ¥Ò»µÄÒ»¸öupdate±í  ²»»áËÀËø

ÒýÓÃ
Èç¹ûÖ»Êǵ¥Ò»µÄÒ»¸öupdate±í  ²»»áËÀËø


ÄãºÃ£¬ÎÊÌâÊÇÎÒÏÖÔÚÊÇ2¸ö³ÌÐò updateͬһ¸ö±íÄØ¡£¡£ ÇëÎÊÓа취Âð

²¢·¢²Ù×÷ÊÇÊý¾Ý¿âϵͳһ¸öÖØÒªÌØÕ÷£¬ËùÒÔ²»Òª¶ã±Ü²¢·¢
¶Ô²¢·¢²Ù×÷µÄ´¦Àí¿Ï¶¨Éæ¼°Ëø£¬Ñ¡ÔñºÏÊʵÄËøÐÐΪÀ´´ïµ½ÎÒÃǵÄÒªÇóÊÇÎÒÃÇÐèÒª¿¼Âǵġ£


²¢·¢²Ù×÷ÊÇÊý¾Ý¿âϵͳһ¸öÖØÒªÌØÕ÷£¬ËùÒÔ²»Òª¶ã±Ü²¢·¢
¶Ô²¢·¢²Ù×÷µÄ´¦Àí¿Ï¶¨Éæ¼°Ëø£¬Ñ¡ÔñºÏÊʵÄËøÐÐΪÀ´´ïµ½ÎÒÃǵÄÒªÇóÊÇÎÒÃÇÐèÒª¿¼Âǵġ£


ÒýÓÃ
²¢·¢²Ù×÷ÊÇÊý¾Ý¿âϵͳһ¸öÖØÒªÌØÕ÷£¬ËùÒÔ²»Òª¶ã±Ü²¢·¢
¶Ô²¢·¢²Ù×÷µÄ´¦Àí¿Ï¶¨Éæ¼°Ëø£¬Ñ¡ÔñºÏÊʵÄËøÐÐΪÀ´´ïµ½ÎÒÃǵÄÒªÇóÊÇÎÒÃÇÐèÒª¿¼Âǵġ£



ÇëÎÊÄܾٸöÀý×ÓÂð£¿ ËøµÄÀý×Ó£¬ ÎÒ»¹²»Ì«»á°¡

ÒýÓÃ
ÇëÎÊÒ»ÏÂÔÚSQL Server2005 Ï£¬ ÔÊÐí¶à¸ö½ø³ÌͬʱÐÞ¸ÄÒ»¸ö±íÂð£¿
ÎÒÊÇ2¸ö½ø³Ì¶¼Òª¸üÐÂij¸ö±í£¬ºÃÏñÎÒÏÖÔÚÕâÑù²Ù×÷»áÈÃÊý¾Ý¿âËÀËøÁË£¬
Èç¹û²»ÄÜͬʱ²Ù×÷£¬ÄÇÎÒÓ¦¸ÃÈçºÎÐÞ¸ÄÄØ£¿»òÕß˵ÄÄÀïÓÐÉèÖÃʹµÃ¿ÉÒÔͬʱ²Ù×÷Âð£¿
¸úËøÓйØÏµÂð


ÀíÂÛÉϲ»´æÔÚͬʱ¸ÄµÄ×´¿ö£¬¶¼Êǰ´ÕÕÒ»¶¨Ë³ÐòÐ޸ĵġ£ËùÒÔ²ÅÓÐÁËËøµÄ´¦Àí·½Ê½¡£

ÈçºÎÐ޸ĵϰ£¬»¹µÃ¿´ÒµÎñÒªÇó¡£



ÒýÓÃ


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ