SQL Server 2000µÄJDBCÁ¬½ÓÎÊÌâ½â¾ö·½·¨
¾¹ýºÃ¼¸ÌìµÄ·ÜÕ½£¬JDBCÖÕÓڳɹ¦Á¬½ÓÁËSQL Server 2000£¬ÆÚ¼ä×ßÁ˲»ÉÙÍä·£¬ÔÚÕâÀï·ÖÏíÎÒµÄÒ»µã¾Ñé
Ò»¡¢ÎҵĻ·¾³
Windows XP+JDK6u15+Microsoft SQL Server 2000£¨SP4£©+JCreator
ÎÒÏÈÔÚÍøÉÏÏÂÔØÊý¾Ý¿âÇý¶¯³ÌÐò£¬Ä¿Â¼ÏÂÓÐÈý¸ö°ümsbase.jar mssqlserver.jar msutil.jar
1¡¢ÔÚÃüÁîÐÐϱàÒëÔËÐУ¬ÅäÖû·¾³±äÁ¿ ½«ÕâÈý¸ö°üµÄ·¾¶¼ÓÈëCLASSPATHÖÐ
£¨ÎÒÊÇÖ±½Ó½«Õâ3¸ö°ü¸´ÖƵ½E:\Java\lib\extÎļþ¼ÐÏ£¬ÒòΪÕâÊÇÎÒµÄJava°²×°Ä¿Â¼£©
2¡¢ÔÚJCreatorÖÐ ÅäÖà ѡÏî JDKÅäÖÃÎļþ ±à¼ Ìí¼Ó´æµµÂ·¾¶ Ìí¼ÓÈý¸ö°ü
3¡¢ÔÚEclipse´ËÖÐ Ñ¡ÔñÏîÄ¿µÄ¹¹½¨Â·¾¶——¿â—— Ìí¼ÓÍⲿJAR ½«ÕâÈý¸öÌí¼Ó½øÈ¥
£¨2¡¢3ûÊÔ¹ý£¬ÒòΪÎÒÒ»°ãÌí¼Ó¶îÍâµÄJARÎļþ°ü¶¼ÊÇ·ÅÈëÉÏÃæ˵µÄÄǸöĿ¼ÖеÄÒ²¾ÍÊÇclasspath£©
¶þ¡¢³öÏÖµÄÎÊÌâ¼°½â¾ö°ì·¨
1¡¢ÊDz»ÊdzöÏÖÁËError establishing socketÖ®ÀàµÄ´íÎó ºÇºÇ
ÕâÊÇÒòΪÁ¬½ÓÊý¾Ý¿âµÄ1433¶Ë¿Úû´ò¿ª ÎÒÃDZØÐëÒªÏÂÔØSP4µÄ²¹¶¡
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=zh-cn
ÊÂʵÉÏÎÒ¾ÍÊÇÏÂÔصÄSP4²¹¶¡£¬½«
SQL2000.AS-KB884525-SP4-x86-CHS.EXE£¬
SQL2000.MSDE-KB884525-SP4-x86-CHS.EXE£¬
SQL2000-KB884525-SP4-x86-CHS.EXE
Õâ3¸öÎļþÈ«²¿ÏÂÔØ£¬È»ºóÈ«²¿½âѹ£¬×îºóÔËÐÐsetup.batÎļþ£¬¾Í¿ÉÒÔ°²×°SP4²¹¶¡ÁË¡£ÍêÁËÖ®ºóÊÔÊÔ¿´³ÌÐò£¬ÕæOKÁË£¡
Èý¡¢²¹³ä
дÁ¬½Ó´úÂëʱÐèҪעÒâ2000ºÍ2005µÄ²»Í¬£º
1¡¢Á¬½ÓSqlServer2000
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
URL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tempdb";
2¡¢Á¬½ÓSqlServer2005
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
URL = "jdbc:sqlserver://localhost:1433;DatabaseName=tempdb";  
Ïà¹ØÎĵµ£º
´ò¿ª²éѯ·ÖÎöÆ÷£¬ÊäÈëÃüÁî¼´¿É¡£ DUMP TRANSACTION Êý¾Ý¿âÃû WITH NO_LOG
Èç¹û¾õµÃ·¢ÏÖLDFÎļþÕ¼ÓôÅÅ̿ռ仹ÊǺܴó¡£
Çë´ò¿ªÆóÒµ¹ÜÀíÆ÷--ÓÒ¼üµã»÷ÐèѹËõµÄÊý¾Ý¿â--ËùÓÐÈÎÎñ--ÊÕËõÊý¾Ý¿â--ÊÕËõÎļþ--Ñ¡ÔñÈÕÖ¾Îļþ--ÔÚÊÕËõ·½Ê½ÀïÑ¡ÔñÊÕËõÖÁXXM,ÕâÀï»á¸ø³öÒ»¸öÔÊÐíÊÕËõµ½µÄ×îСMÊý,µ÷ÕûÈ·¶¨¼´¿É¡£
Technorati ±êÇ©: SQL ......
ʹÓùý Access µÄÅóÓѶ¼ÖªµÀ£¬Access ÀïÓиö“ÊÇ/·ñ”Êý¾ÝÀàÐÍ£¬ÔÚ SQL Server ÖУ¬Ã»ÓÐÕâ¸öÃû³Æ£¬¶øʹÓà bit¡£ÔÚʹÓùý³ÌÖÐÓм¸µãÐèҪעÒâµÄ£º
£±¡¢bit Óë SQL Server µÄÕûÐͺÍÊý×ÖÊý¾ÝÏàËƵÄÊý×ÖÊý¾Ý£¬µ« bit ÁÐÖ»ÄÜ´æ´¢ 0 ºÍ 1¡£
£²¡¢ÔÚ²åÈë¡¢ÐÞ¸Ä bit Êý¾Ýʱ£¬Ê¹Óà 0 »ò 1 £¬¶ø²»ÊÇ false »ò true£¬bit ×Ö¶ ......
create table #a
(
a int identity(1,1) primary key,
b int default(0) not null,
c nvarchar(20)
)
insert into #a(c)
select 'a' union all
select 'b' union all
select 'c' union all
select 'd' union all
select 'e'
select * from #a
alter table #a drop constraint DF__#a_____________b__12 ......
update CHELIANG_MINGDAN set clmd_yunxuzaizhong = cast(clmd_yunxuzaizhong/1000 as decimal(14,4)) where clmd_yunxuzaizhong is not null
update CHELIANG_MINGDAN set clmd_carweight = cast(clmd_carweight/1000 as decimal(14,4)) where clmd_carweight is not null ......
pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øʹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
ÔÚ oracle ÖÐËùÓеĴíÎ󶼱»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......