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

SQL 2005ÆóÒµ°æ

ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: SQL ÍøÂç½Ó¿Ú, error: 26 - ¶¨Î»Ö¸¶¨µÄ·þÎñÆ÷/ʵÀýʱ³ö´í)


=========================================

vs2008 ×Ô´øµÄ2005ûÓÐÎÊÌâ,ÔËÐÐÒ»ÇÐÕý³£

»»³É2005ÆóÒµ°æ,¾Í³öÏÖÕâ¸öÎÊÌâ,ÓÐË­ÖªµÀÊÇʲôԭÒò

via·þÎñ½ûÖ¹,ÆäËû3¸ö¶¼Æô¶¯, ÍâΧÅäÖõķþÎñÆô¶¯ÔÚ,Ô¶³ÌÁ¬½ÓÑ¡ÔñµÄÊÇ Í¬Ê±Ê¹ÓÃTCP/IPºÍnamed pipes

http://blog.csdn.net/js_szy/archive/2009/08/30/4499304.aspx

ÄãÕâ¸öÉÏÃæ²»ÊÇÎÒÒªµÄ°¡



ip/ʵÀýÃû
sa
saÃÜÂë

²½Öè1£ºÔÚSQLServer ʵÀýÉÏÆôÓÃÔ¶³ÌÁ¬½Ó
1.Ö¸Ïò¡°¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷¡±
2.ÔÚ¡°SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷¡±Ò³, µ¥»÷¡°·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷¡±
3.È»ºóµ¥»÷Õ¹¿ª¡°Êý¾Ý¿âÒýÇæ¡±£¬ Ñ¡ÖС°Ô¶³ÌÁ¬½Ó¡±£¬ÔÚÓÒ±ßÑ¡ÖС°±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó¡±£¬
ÔÙÑ¡ÔñҪʹÓõÄЭÒ飬( Õâ¸öµØ·½Ó¦µ±ÆôÓÃTCP/IP ºÍÃüÃû¹ÜµÀ·þÎñ£¡)µ¥»÷¡°Ó¦Óá±£¬Äú»á¿´µ½ÏÂÏûÏ¢£º
¡°Ö±µ½ÖØÐÂÆô¶¯Êý¾Ý¿âÒýÇæ·þÎñºó£¬¶ÔÁ¬½ÓÉèÖÃËù×öµÄ¸ü¸Ä²Å»áÉúЧ¡£¡±£¬µ¥»÷¡°È·¶¨¡±°´Å¥·µ»Ø
4.Õ¹¿ª¡°Êý¾Ý¿âÒýÇæ¡±£¬ Ñ¡ÖС°·þÎñ¡±£¬ÔÚÓұߵ¥»÷¡°Í£Ö¹¡±£¬µÈµ½ MSSQLSERVER ·þÎñÍ£Ö¹£¬
È»ºóµ¥»÷¡°Æô¶¯¡±£¬ÖØÐÂÆô¶¯MSSQLSERVER ·þÎñ¡£
²½Öè2£ºÆôÓà SQLServer ä¯ÀÀÆ÷·þÎñ
1.Ö¸Ïò¡°¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷¡±
2.ÔÚ¡°SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷¡±Ò³, µ¥»÷¡


Ïà¹ØÎÊ´ð£º

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

sql ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

sql ÎÊÌâ

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

string sql
sql = dw_1.GetSQLSelect()+"Where (StartTime> '"+startTime+"') and (EndTime ......

sqlÓï¾ä

create table jskb(
񅧏 int identity(1,1) primary key not null,
ÐÕÃû varchar(20) not null,
ÐÔ±ð char(1) not null ,
ÊÚ¿ÎÃû varchar(10) not null,
½ÌÊҺŠint(10)
)

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