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

ÔõôÁ¬½Ó°²×°Ê±Ã»ÓÐʹÓÃĬÈÏʵÀýµÄSQL Server2000?

A»úÆ÷£¨XP£©£¨10.10.6.65£©ÍêÕûµÄ¼ÆËã»úÃûÊÇ: DZD·þÎñÆ÷

ÎÒ×°ÁËÒ»¸ö¸öÈ˰棺 SQLServer2000,´´½¨ÁËÒ»¸öʵÀýÃûΪ£ºMYINSTANCE

×°ÁË£ºdotNetFx35setup.exe

²¢´òºÃÁËSP4²¹¶¡£ºSQL2000-KB884525-SP4-x86-CHS.EXE£¬

ÔÚ±¾»úÓòéѯ·ÖÎöÆ÷,ÔÚSQL Server(s)ÖÐÊäÈ룺 DZD·þÎñÆ÷\MYINSTANCE

ÓÃSQL ServerÉí·ÝÑéÖ¤£º Óû§Ãûsa ÃÜÂë123  ¿ÉµÇ¼½øÐвéѯ

µ«ÎªÊ²Ã´ÎÒÔÚ¾ÖÓòÍøÄÚB»úÆ÷£¨10.10.6.114£©£¬Óòéѯ·ÖÎöÆ÷,ÔÚSQL Server(s)ÖÐÊäÈ룺 DZD·þÎñÆ÷\MYINSTANCE

ÓÃSQL ServerÉí·ÝÑéÖ¤£º Óû§Ãûsa ÃÜÂë123  µÇ¼²»ÁË£¬
ÔÚSQL Server(s)ÖÐÊäÈ룺10.10.6.65  Ò²µÇ¼²»ÁË£¬ÎªÊ²Ã´°¡?
1433¶Ë¿Ú´ò¿ª
·À»ðǽ
ÄѵÀÒªÅähost

ÔÚÆäËû»úÆ÷Éϲéѯ·ÖÎöÆ÷Äܵǽ±¾»úµÄ²éѯ·ÖÎöÆ÷°¡???·Â·ðÖ»ÄÜ×¢²á

¾ÖÓòÍøÄÚ ·þÎñÆ÷Ãûд :DZD·þÎñÆ÷,¶Ë¿ÚºÅ£¬¶ø²»ÊÇ:DZD·þÎñÆ÷\MYINSTANCE

ÎÒд³É£º'DZD·þÎñÆ÷,1433' ÔõôҲÁ¬²»Éϰ¡£¿

DZD·þÎñÆ÷\MYINSTANCE
DZD·þÎñÆ÷,1433
¶¼ÐУ¡
ÊÇ·À»ðǽû¹Ø£¬Ð»Ð»£¡
´óˮţ£¬ÌìÌì¼û°¡£¡

´ó½ÇÅ£


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

ÇóÕâ¾äSqlÈçºÎÀí½â

create table [¿Í»§ÁªÏµ±í]([¿Í»§±àºÅ] varchar(2),[ÁªÏµÈÕÆÚ] datetime,[ÁªÏµÄÚÈÝ] int)
insert [¿Í»§ÁªÏµ±í]
select 'aa','2009/01/01',111 union all
select 'bb','2009/02 ......

ÈçºÎʵÏÖSQL Server±¨±í¶¨Ê±Êä³ö

ÏÖÔÚÐèÒªÔÚSQL ServerʵÏÖ¶¨Ê±±¨±íÊä³öµÄ¹¦ÄÜ£¬
ÀýÈçÔÚÿÌìµÄ12µãÉú³Éµ±ÌìµÄ±¨±í£¬²¢Êä³öµ½Excel»òÆäËü¸ñʽµÄÎļþÖС£
ÎÒµ÷²éÁËһϣ¬ËµSQL Server ±¨±í·þÎñÓÐÕâ¸ö¹¦ÄÜ£¬µ«ÊÇûÓùý±¨±í·þÎñ£¬²»ÖªÈçºÎʵÏÖ£¬Çë ......

SQLÓï¾äÎÊÌâ

¿¼ÇÚ±ífty_grzl£¨mem_id  Ô±¹¤ID£¬adate  ÈÕÆÚ£¬type ÀàÐÍ£¬a1-a6  ´ò¿¨Ê±¼ä£¬jb »ù±¾¹¤Ê±£¬ot ¼Ó°à¹¤Ê±£¬cdd ³Ùµ½´ÎÊý£¬ztd ÔçÍË´ÎÊý£¬cdt ³Ùµ½Ê±¼ä£¬ztt ÔçÍËʱ¼ä£©
type£ºN Äê¼Ù£¬W Õý³£°à£¬J ......

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ