Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

Çë½Ì¸÷λ´ó¸çÒ»¸öSqlÎÊÌ⣬Äĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¿

СµÜ×î½üÓöµ½Ò»¸öÎÊÌ⣬ҪÇóµÃ³öÄĸö°à¼¶µÄ½Ìʦ´ýÓö×î¸ß£¬°Ñͬһ¸ö°à¼¶µÄ½Ìʦ´ýÓöºÏ¼ÆÆðÀ´


°à¼¶±í                  ½Ìʦ±í

°à¼¶ID                ½ÌʦID
°à¼¶Ãû×Ö            ......

[ÉêÃ÷:ÐÂÊÖ]sqlÊý¾Ý¿â¸½¼ÓºÍÁ¬½ÓµÄÎÊÌâ!

    ´ó¼ÒºÃ,ÕæÕæ¶ùµÄÊÇÐÂѧ,ʵÔÚÊDz»¶®,ƽʱÀÏʦ½²µÄ¶¼Òª¸½¼ÓSQLÊý¾Ý¿â,ºÍÉèÖÃweb.configÎļþÀïµÄsaÕ˺źÍÃÜÂë,¿É´«µ½¿Õ¼äÀïÀϳö´í. ÐéÄâ¿Õ¼äÀ︽¼ÓÊý¾Ý¿âºÍweb.configÎļþÀïµÄÕ˺ÅÃÜÂëÎÊÌâÔõô½â¾ö?¿Õ¼äûÓÐÎÊÌâ,ÊÇÈ«ÄܵÄ,´«Á˼òµ¥µÄaspxÎļþ²âÊÔûÓÐÎÊÌâ,¿ÉÒ»µ½Á¬Êý¾Ý¿âÕâ¶ù¾Í²»Ì±ÁË,Ôõô¶¼²»ÐÐ,ÊDZ¾µØºÍÉÏ´«µ ......

ÎÊÒ»¸öÈõÖǵÄÎÊÌ⣺sql 2008ÔõôÌí¼ÓÒ»¸öÓÐÃÜÂëµÄÓû§

¸Õ½Ó´¥sql 2008£º°²×°sql 2008ʱ£¬Ö»Ñ¡Á˸öwindowÈÏÖ¤µÄÓû§£¬ÏÖÔÚÏë¼Ó¶àÒ»¸öÓÐÃÜÂëµÄÓû§£¬ÇëÎÊÓÐÄÄλ´óÏÀÖªµÀÔõôŪ¡£¡£¡£¡£ÎÒÔõôҲûÕÒµ½Ïñsql 2000ÄÇÑùÓÐÓû§¹ÜÀíµÄÄǸöÏî

ÓÃÃüÁîÐУº
CREATE USER abc WITH PASSWORD '123'

CREATE USER abc WITH PASSWORD ='123'

¶¼±¨´í£¡£¡£ ......

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

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

µ«ÊÇÖмäµÄת»»Ëƺõ³ýÁËÎÊÌ⣬ûÓÐÊý¾Ý
Çë¸÷λ°ïæ¿´¿´ÊDz»ÊÇÄÄÀï³öÁË ......

Çë½ÌSQLµ¼³öExcel

ÏÖÔÚÎÒÓÐÒ»ÕÅÊý¾Ý±í£¬Êý¾Ý±íÖеÄÊý×ÖÊÇËæ»úÅÅÁеõ½µÄ£¬½á¹¹ÈçÏ£º
----------------------------------------
ID    Cols1    Cols2    ¡­¡­    Cols24
1    45      66      ¡­¡­    77
2    53&n ......

ÇósqlÓï¾ä

pln_id netnode_id
1          2
2          3
1          3
2          4

ÎÒ Ïë°Ñ pln_id ÏàͬµÄÏî±ä³É Ò»ÐÐ
¾ÍÊÇ
1 2 3
2 3 4
ÇëÖ¸½Ì
ÊÇÕâ¸öÂð
select pln_id,replace(wm ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [4329] [4330] [4331] [4332] 4333 [4334] [4335] [4336] [4337] [4338]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ