sql Êý¾Ýµ¼ÈëÎÊÌâ
Ï£Íû×öÒ»¸öÊ«¸èÈ«¼¯µÄÊý¾Ý¿â£¬ËùÒÔ´òË㽫ʫ¸èÎı¾µ¼Èëµ½Êý¾Ý¿âÀÔÙͨ¹ýÒýÓÃÊý¾Ý¿âÔÚÍøÒ³ÖÐÏÔʾʫ¸è¡£ÓÉÓÚÎÒÊǸսӴ¥Êý¾Ý¿â£¬²»ÊǺܶ®£¬Ï£Íû´ó¼Ò¸øÎÒЩÒâ¼û¡£
ÎÒÏÖÔÚÉè¼ÆÁËid£¬title£¬author£¬date£¬style£¬contentÕâЩ×ֶΡ£ÆäÖÐcontent£¬ÊǾßÌåµÄÊ«¸èÎı¾£¬ÒòΪÓÐЩÎÄ×ֶ࣬ÓÐЩÎÄ×ÖÉÙ£¬¶øÇÒ»¹ÓÐÒ»¶¨¸ñʽ£¨ÊÇ·ñÄܰüº¬¸ñʽ£¿£¿£©¡£ÎÒ¾ÍÊDz»Çå³þ£¬Õâô¶àÎÄ×ÖÇÒÊÇ·ÖÐÐÌ壬ÈçºÎÊäÈëµ½Êý¾Ý¿âÄÚ¡£Ð»Ð»´ó¼Ò¡£
http://blog.csdn.net/babylon_0049/archive/2008/12/23/3590063.aspx
BULK INSERT
Îı¾¸ñʽ¿ÉÒÔÉèÖóÉnvarchar¸ñʽµÄ Ö±½Óµ¼Èë
Ïà¹ØÎÊ´ð£º
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô
select parsen ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
Êý¾Ý¿âÒªÔõôѧ²Å²»»áÏԵóéÏó°¡£¿
Õâ¾ÍÒª¿´ÄãÊʺÏʲô·½·¨ÁË£¬Õâ¾ßÌå²»ºÃ˵µÄ.....
ÔõôÁË£¬ÄѵÀ´ó¼Ò¶¼²»»á£¬»¹ÊÇÕæµÄÌ«³éÏó´ó¼Ò²»ÖªµÀÔõô˵°¡
½áºÏÄã²Ù×÷Êý¾Ý¿âµÄÌå»áºÍÀí½â£¬Ó¦¸ÃЧ¹û»á¸üºÃ¡£·ñÔò£¬Ò ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
±í
id bh
1 10
2 11
3 12
4 15
5 16
6 22
7 25
8 26
9 27
10 28
½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º
10~12£¬15~16£¬22£¬25~28
SQL code:
declare @t tabl ......