JDBCÁ¬½ÓSQLServer³öÏÖµÄÒì³£
¿Î³ÌÉè¼ÆµÄµÚÒ»²½£º
Óû§µÇ½ģ¿é:¾ÍÕâ¸öСģ¿é°ÑÎÒÕûËÀÁË£¬³öÏÖµÄÎÊÌâÒ»¸ö½Ó×ÅÒ»¸ö£¬×îÖ÷ÒªµÄ¾ÍÊÇÊý¾Ý¿âÁ¬½Ó.
question1.
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
Òì³£ÔÒò£ºÃ»Óе¼Èëµ¼Çý¶¯°üsqljdbc.jar.
question2.
com.microsoft.sqlserver.jdbc.SQLServerException: ûÓÐΪ¼¯³ÉÉí·ÝÑéÖ¤ÅäÖÃÇý¶¯³ÌÐò
Òì³£ÔÒò£º´òsqlserver2005µÄsp3µÄ²¹¶¡£¬È»ºó½«Êý¾Ý¿âÉèÖÃΪÓÃwindows+sqlserverË«ÖØÑéÖ¤¡£
question3.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]¶ÔÏóÃû ‘xxx’ ÎÞЧ
Òì³£ÔÒò:·ÃÎÊÊý¾Ý¿âµÄÓû§ÓеǼȨÏÞ£¬µ«ÎÞ²Ù×÷±íµÄȨÏÞ
½â¾ö°ì·¨£º
1. ÔÚ[ÆóÒµ¿ØÖÆ̨]´°¿Ú–[Ê÷]×Ó´°¿Ú–[°²È«ÐÔ]×ÓÊ÷–[µÇ¼]ÏîÀォÄãʹÓõĵǽÓû§µÄĬÈÏÊý¾Ý¿âÉèΪÄãËùʹÓõÄÊý
¾Ý¿â¡£
2. ÔÚ[ÆóÒµ¿ØÖÆ̨]´°¿Ú–[Ê÷]×Ó´°¿Ú–[°²È«ÐÔ]×ÓÊ÷–[µÇ¼]ÏîÀïÐÂÔöÒ»¸öµÇ¼Óû§£¨ÔÚÆäÖÐÑ¡ÔñSQL Server Éí·ÝÑéÖ¤
¡¢·þÎñÆ÷½ÇÉ«ºÍÒª·ÃÎʵÄÊý¾Ý¿â£©£¬ÒÔºó±ã¿ÉÓÃЩÐÂÔöÓû§·ÃÎÊÄã¹´Ñ¡µÄÊý¾Ý¿âÁË¡£
question4.
java.sMS-sql 2005 ''xxx'' (Êý¾Ý¿â ''xxx''£¬¼Ü¹¹ ''dbo'')µÄ SELECT ȨÏÞ
Òì³£ÔÒò:Sql server 2005 ĬÈÏÉèÖÃϲ»ÔÊÐíÔ¶³ÌµÇ½
1 ÍâΧÉèÖà tcp/ip ºÍ named pipe ͬʱÆôÓÃ
2 ·þÎñÆ÷ --¡µÊôÐÔ --¡µ°²È«ÐÔ --¡µsql server ºÍwindows ÈÏ֤ģʽ ,Êý¾Ý¿â(xxx) --->°²È«ÐÔ---->¼Ü¹¹---->dbo(Êô
ÐÔ)--->ȨÏÞ--->Ìí¼Ó--->ä¯ÀÀ-->
[public]---->¾ßÓÐÊÚÓèȨÏÞ(select)
question5.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor
position.
Òì³£ÔÒò:ResultSetʵÀýresûÓÐÒƶ¯Ö¸ÕëλÖá£Ò»¸öResultSetÖ¸Õë×î³õµÄλÖÃÔÚµÚÒ»Ìõ¼Ç¼֮ǰ£¬µÚÒ»´Îµ÷ÓÃnext·½·¨
ʹµÚÒ»Ìõ¼Ç¼´¦ÓÚµ±Ç°Î»Ö㬵ڶþ´Îµ÷ÓÃnext·½·¨£¬Ê¹µÚ¶þÌõ¼Ç¼´¦ÓÚµ±Ç°Î»Öá£
Ïà¹ØÎĵµ£º
´¥·¢Æ÷µÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
´´½¨ DML »ò DDL ´¥·¢Æ÷¡£´¥·¢Æ÷ÊÇÊý¾Ý¿â·þÎñÆ÷Öз¢Éúʼþʱ×Ô¶¯Ö´ÐеÄÌØÖÖ´æ´¢¹ý³Ì¡£Èç¹ûÓû§ÒªÍ¨¹ýÊý¾Ý²Ù×÷ÓïÑÔ (DML) ʼþ±à¼Êý¾Ý£¬ÔòÖ´ÐÐ DML ´¥·¢Æ÷¡£DML ʼþÊÇÕë¶Ô±í»òÊÓͼµÄ INSERT¡¢UPDATE »ò DELETE Óï¾ä¡£DDL ´¥·¢Æ÷ÓÃÓÚÏìÓ¦¸÷ÖÖÊý¾Ý¶¨ÒåÓïÑÔ (DDL) ʼþ¡£ÕâЩÖ÷ÒªÊÇ CRE ......
Ë÷ÒýµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
Ϊָ¶¨±í»òÊÓͼ´´½¨¹ØϵË÷Òý£¬»òΪָ¶¨±í´´½¨ XML Ë÷Òý¡£¿ÉÔÚÏò±íÖÐÌîÈëÊý¾ÝÇ°´´½¨Ë÷Òý¡£¿Éͨ¹ýÖ¸¶¨ÏÞ¶¨µÄÊý¾Ý¿âÃû³Æ£¬ÎªÁíÒ»¸öÊý¾Ý¿âÖеıí»òÊÓͼ´´½¨Ë÷Òý¡£
Transact-SQL Óï·¨Ô¼¶¨
Óï·¨
Create Relational Index CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] IN ......
´æ´¢¹ý³ÌµÄ´´½¨¼°Ê¹ÓÃ(sqlserver 2005)
´´½¨´æ´¢¹ý³Ì¡£´æ´¢¹ý³ÌÊÇÒѱ£´æµÄ Transact-SQL Óï¾ä¼¯ºÏ£¬»ò¶Ô Microsoft .NET Framework ¹«¹²ÓïÑÔÔËÐÐʱ (CLR) ·½·¨µÄÒýÓ㬿ɽÓÊÕ²¢·µ»ØÓû§ÌṩµÄ²ÎÊý¡£¿ÉÒÔ´´½¨¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°£¨¾Ö²¿ÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓ㬻òÔÚËùÓлỰ£¨È«¾ÖÁÙʱ¹ý³Ì£©ÖÐÁÙʱʹÓá£
Æô¶¯ SQL ......
BULK INSERT
¡¡¡¡ÔÚSQL ServerÖУ¬BULK INSERTÊÇÓÃÀ´½«ÍⲿÎļþÒÔÒ»ÖÖÌض¨µÄ¸ñʽ¼ÓÔص½Êý¾Ý¿â±íµÄT-SQLÃüÁî¡£¸ÃÃüÁîʹ¿ª·¢ÈËÔ±Äܹ»Ö±½Ó½«Êý¾Ý¼ÓÔص½Êý¾Ý¿â±íÖУ¬¶ø²»ÐèҪʹÓÃÀàËÆÓÚIntegration ServicesÕâÑùµÄÍⲿ³ÌÐò¡£ËäÈ»BULK INSERT²»ÔÊÐí°üº¬Èκθ´ÔÓµÄÂß¼»òת»»£¬µ«Äܹ»ÌṩÓë¸ñʽ»¯Ïà¹Øµ ......
ÊÀʶ´Ã÷½ÔѧÎÊ£¬ÈËÇéÁ·´ï¼´ÎÄÕ¡£×öASPʱ£¬×î³£ÓõÄÊý¾Ý¿â¼´SqlserverÓëAccessÊý¾Ý¿âĪÊôÁË£¡
µ«Ê¹Óûᾳ£·¢ÏֺܶàSQLÖ´ÐеÄÎÊÌâ¡£ÕâÀïÕûÀí³öÖ®¼äµÄ²îÒ죬×ö¸öÊ®´ó²îÒìµÄ×ܽᡣ
ACCESS½á¹¹¼òµ¥ÈÝÒ×´¦Àí£¬¶øÇÒÒ²ÄÜÂú×ã¶àÊýµÄÍøÕ¾³ÌÐòÒªÇó£¬Ò²ÊdzõѧÕßµÄÊÔÅ£µ¶¡£
ACCESSÊÇСÐÍÊý¾Ý¿â£¬¼ÈÈ»ÊÇСÐ;ÍÓÐËû¸ù±¾µÄ¾ÖÏÞÐÔ£º
......