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

ÐéÄâÖ÷»úÉϵÄSql Server05·ÃÎʲ»ÁËÁË¡£Ìáʾ´íÎó£º4064



ÎÒÔø¾­ÔÚ±¾µØÊý¾Ý¿âÉϽ¨ÁËÒ»¸öÓëÐéÄâÖ÷»úÊý¾Ý¿âÓû§ÃûͬÃûµÄÓû§£¬ºóÀ´ÓÖɾµôÕâ¸öÓû§ÁË¡£
²»ÖªµÀÊDz»ÊÇÕâ¸öÔ­ÒòÒýÆðµÄ¡£

Èç¹ûÊÇ£¬ÔõôÐÞ¸´ÄØ£¿

ÒýÓÃ
ÄãµÄ虛擬機ÉÏÓÐnanhe這個帳號嗎? ÓÃsaµÇ陸¿ÉÒÔ嗎?

nanheÕâ¸öÕʺÅÊÇËûÃÇ·ÖÅ䏸Îҵġ£
ÒòΪÊÇÔ¶³ÌÐéÄâÖ÷»ú·þÎñÉÌÌṩµÄ¿Õ¼ä£¬ËùÒÔÎÒûÓÐsa¸ùÏÞ¡£



ÎÞ·¨´ò¿ªÄ¬ÈÏÊý¾Ý¿â,ÄãµÇ¼Óû§µÄĬÈÏÊý¾Ý¿âÓÐû?ȨÏÞÊǸöÎÊÌâ,
Äã¿´Ò»ÏÂÖ±½ÓÔ¶³Ì×ÀÃæÁ¬½Óµ½·þÎñÆ÷¿´Ðв»?

¼ì²éһϵǽÕË»§ÔÚĬÈÏÊý¾Ý¿âÉÏÊÇ·ñÓжÔÓ¦µÄÓû§ÕÊ»§»òÕßĬÈÏÊý¾Ý¿âÖÐµÄ guest ÕË»§ÊÇ·ñÆôÓá£

ÏÖÔÚΪֹ·þÎñÉÌÄDZßûÓлظ´¡£

ÎÒÏëÎʵÄÊÇ£ºÓ¦¸Ã²»ÊÇÒòΪÎÒÔÚ±¾µØÊý¾Ý¿âÉϽ¨ÁËÓëÔ¶³ÌÊý¾Ý¿âÓû§ÃûÒ»ÑùµÄÓû§£¬ºóÀ´É¾µôÕâÒýÆðµÄ°É£¿

ËüÁ©Ó¦¸ÃÊǶÀÁ¢µÄ²»ÊÇÂ𣿱¾µØºÍÔ¶³ÌÊý¾Ý¿â¡£

ÎÊÌâÊÇǡǡÊÇÔÚÎÒÔÚ±¾µØ½¨ÁËͬÃûÓû§£¬ÔÙɾµôºó£¬Ô¶³ÌµÄÊý¾Ý¿â¾Í·ÃÎʲ»ÁËÁË.

ÒýÓÃ
ÏÖÔÚΪֹ·þÎñÉÌÄDZßûÓлظ´¡£

ÎÒÏëÎʵÄÊÇ£ºÓ¦¸Ã²»ÊÇÒòΪÎÒÔÚ±¾µØÊý¾Ý¿âÉϽ¨ÁËÓëÔ¶³ÌÊý¾Ý¿âÓû§ÃûÒ»ÑùµÄÓû§£¬ºóÀ´É¾µôÕâÒýÆðµÄ°É£¿

ËüÁ©Ó¦¸ÃÊǶÀÁ¢µÄ²»ÊÇÂ𣿱¾µØºÍÔ¶³ÌÊý¾Ý¿â¡£

ÎÊÌâÊÇǡǡÊÇÔÚÎÒÔÚ±¾µØ½¨ÁËͬÃûÓû§£¬ÔÙɾµôºó£¬Ô¶³ÌµÄÊý¾Ý¿â¾Í·ÃÎʲ»ÁËÁË.

²»»áÒòΪÄãɾ³ý±¾µØÕʺŷÃÎʲ»Á˵ģ¬Õâ¸öÊÇûÓйØÏµµÄ¡£

ÄãÊDz»ÊÇɾ³ý´íÁË£¿É¾³ÉÁË·þÎñÆ÷µÄÕʺţ¿

ÒýÓÃ
ÏÖÔÚΪֹ·þÎñÉÌÄDZßûÓлظ´¡


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

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

sql ÎÊÌâ

PBÖпª·¢µÄ¡£

DateTime startTime=DateTime(em_1.Text)
DateTime endTime=DateTime(em_2.Text)

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+&q ......

dbf±íµ¼Èëµ½sql server2000±íÎÊÌâ

ÇëÎÊ£º
1,ÈçºÎ½«Ò»ÕÅdbf±íµ¼Èëµ½sql server2000ÖеÄÒ»ÕÅ±í¡£Ê¹ÓÃDTS¸ÃÔõÑùʵÏÖ£¿
2,ʹÓÃÍøÉÏ´úÂ룺
Insert Into Tb_cj Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro D ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ