SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
ÊÕ²Ø
--> Title : SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
--> Author : wufeng4552
--> Date : 2009-11-11
SQL ServerÖ®·Ö²¼Ê½ÊÂÎñ
(Ò»)¸ÅÄî:
·Ö²¼Ê½ÊÂÎñÊÇÉæ¼°À´×ÔÁ½¸ö»ò¶à¸öÔ´µÄ×ÊÔ´µÄÊÂÎñ¡£Microsoft® SQL Server™ 2000Ö§³Ö·Ö²¼Ê½ÊÂÎñ£¬Ê¹Óû§µÃÒÔ´´½¨ÊÂÎñÀ´¸üжà¸öSQL ServerÊý¾Ý¿âºÍÆäËüÊý¾ÝÔ´¡£
·Ö²¼Ê½ÊÂÎñ°üÀ¨£º
·×ÊÔ´¹ÜÀíÆ÷
¿ØÖÆ·Ö²¼Ê½ÊÂÎñËùÉæ¼°µÄÿ¸ö×ÊÔ´µÄÈí¼þ³ÆΪ×ÊÔ´¹ÜÀíÆ÷¡£·Ö²¼Ê½ÊÂÎñÓɸ÷¸ö×ÊÔ´¹ÜÀíÆ÷Äڵı¾µØÊÂÎñ×é³É¡£Ã¿¸ö×ÊÔ´¹ÜÀíÆ÷±ØÐëÄܹ»Óë·Ö²¼Ê½ÊÂÎñÄÚµÄËùÓÐÆäËü×ÊÔ´¹ÜÀíÆ÷Ïàе÷£¬ÒÔÌá½»»ò»Ø¹ö×Ô¼ºµÄ±¾µØÊÂÎñ¡£SQL Server ¿ÉÒÔ×÷Ϊ·Ö²¼Ê½ÊÂÎñÄÚµÄ×ÊÔ´¹ÜÀíÆ÷¹¤×÷£¬²¢×ñ´ÓÓÃÓÚ·Ö²¼Ê½ÊÂÎñ´¦ÀíµÄ X/Open XA ¹æ·¶¡£
·ÊÂÎñ¹ÜÀíÆ÷
Ìá½»»ò»Ø¹ö·Ö²¼Ê½ÊÂÎñÓɳÆΪÊÂÎñ¹ÜÀíÆ÷µÄÈí¼þ×é¼þ¿ØÖÆ¡£ÊÂÎñ¹ÜÀíÆ÷Óëÿ¸ö×ÊÔ´¹ÜÀíÆ÷Ïàе÷£¬È·±£Ò»ÆðÌá½»»ò»Ø¹öËùÓÐ×é³É·Ö²¼Ê½ÊÂÎñµÄ±¾µØÊÂÎñ¡£Microsoft·Ö²¼Ê½ÊÂÎñ´¦Àíе÷Æ÷ (MS DTC) ·þÎñÈçÊÂÎñ¹ÜÀíÆ÷Ò»Ñù¹¤×÷¡£MS DTC ×ñ´ÓÓÃÓÚ·Ö²¼Ê½ÊÂÎñ´¦ÀíµÄ X/Open XA ¹æ·¶¡£
·Á½½×¶ÎÌá½» (2PC)
ÐèÒª½øÐÐÌØÊâµÄÌá½»´¦Àí£¬ÒÔ·ÀÖ¹ÔÚ¹ÜÀí¿çÔ½¶à¸ö×ÊÔ´¹ÜÀíÆ÷µÄÊÂÎñʱ³öÏÖÎÊÌâ¡£µ±Ë¢ÐÂÈÕÖ¾»º³åÇøʹÆä¿ÉÓÃʱ£¬Ìá½»´óÊÂÎñ¿ÉÄÜÐèÒªÏà¶Ô½Ï³¤µÄʱ¼ä¡£Ìá½»½ø³Ì±¾Éí»¹¿ÉÄÜÓöµ½´íÎó£¬ÐèҪǿÐлعö¡£Èç¹ûÊÂÎñ¹ÜÀíÆ÷Ö»ÊÇÇëÇóÿ¸ö×ÊÔ´¹ÜÀíÆ÷Ìá½»£¬Ôò¿ÉÄÜ´ÓһЩ×ÊÔ´¹ÜÀíÆ÷·µ»Ø³É¹¦×´Ì¬£¬È»ºó´Óij¸ö×ÊÔ´¹ÜÀíÆ÷µÃµ½´íÎóÐÅÏ¢¡£Õâ»áµ¼Ö³åÍ»£¬ÒòΪËùÓзֲ¼Ê½ÊÂÎñ¶¼Ó¦»Ø¹ö£¬¶ø²¿·ÖÊÂÎñÒÑÌá½»¡£Á½½×¶ÎÌύͨ¹ý½«Ìá½»·Ö³ÉÁ½Ïà¿ÉÒÔ½â¾ö´ËÎÊÌ⣺
·×¼±¸
ÊÂÎñ¹ÜÀíÆ÷¸øÿ¸ö×ÊÔ´¹ÜÀíÆ÷·¢ËÍÒ»¸ö×¼±¸Ìá½»µÄÇëÇó¡£È»ºó£¬Ã¿¸ö×ÊÔ´¹ÜÀíÆ÷Ö´ÐÐÍê³ÉÌá½»½ø³ÌËùÐèµÄËùÓдóÁ¿Õ¼ÓÃ×ÊÔ´µÄ²Ù×÷£¬ÈçË¢ÐÂËùÓÐÈÕÖ¾»º³åÇø¡£×ÊÔ´¹ÜÀíÆ÷Ö»±£Áôά»¤ÊÂÎñÍêÕûÐÔËùÐèµÄ×îÉÙµÄËø£¬È»ºó¸øÊÂÎñ¹ÜÀíÆ÷·µ»Ø³É¹¦×´Ì¬¡£
·Ìá½»
Èç¹ûËùÓÐ×ÊÔ´¹ÜÀí¶Ô·¢¸øËüÃǵÄ×¼±¸ÇëÇ󷵻سɹ¦×´Ì¬£¬ÊÂÎñ¹ÜÀíÆ÷½«¸øÿ¸ö×ÊÔ´¹ÜÀíÆ÷·¢ËÍÌá½»ÃüÁȻºó£¬Ã¿¸ö×ÊÔ´¹ÜÀíÆ÷¿ìËÙ½«ÊÂÎñ¼Ç¼ΪÒÑÍê³É£¬²¢ÊÍ·ÅÉϴοØÖƵÄ×ÊÔ´¡£Èç¹ûÓÐÈκÎ×ÊÔ´¹ÜÀíÆ÷¶Ô×¼±¸ÇëÇ󷵻شíÎóÐÅÏ¢£¬ÊÂÎñ¹ÜÀíÆ÷½«¸øÿ¸ö×ÊÔ´¹ÜÀíÆ÷·¢ËͻعöÃüÁî¡£
Óм¸ÖÖ·
Ïà¹ØÎĵµ£º
SQL Server Ë÷Òý½á¹¹¼°ÆäʹÓã¨Èý£©
×÷Õߣºfreedk
Ò»¡¢ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¶þ¡¢¸ÄÉÆSQLÓï¾ä
ʵÏÖСÊý¾ÝÁ¿ºÍº£Á¿Êý¾ÝµÄͨÓ÷ÖÒ³ÏÔʾ´æ´¢¹ý³Ì
¡¡¡¡½¨Á¢Ò»¸ö Web Ó¦Ó㬷ÖÒ³ä¯ÀÀ¹¦Äܱز»¿ÉÉÙ¡£Õâ¸öÎÊÌâÊÇÊý¾Ý¿â´¦ÀíÖÐÊ®·Ö³£¼ûµÄÎÊÌâ¡£¾µäµÄÊý¾Ý·ÖÒ³·½·¨ÊÇ:ADO ¼Í¼¼¯·ÖÒ³·¨£¬Ò²¾ÍÊÇÀûÓÃADO×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¨ÀûÓÃÓÎ ......
use master
go
--Çл»masterÊý¾Ý¿â
if exists(select 1 from sysdatabases where name = N'test')
--×¢Òâ¸ÃͬÃûÊý¾Ý¿âÊÇ·ñ»¹ÒªÓõ½
begin
drop database test
end
go
create database test
on
primary
( name = 'testprimary', --Ö÷Êý¾ÝÎļþÂß¼Ãû
filename = 'D:\testprimary.mdf',--Ö÷Êý¾ÝÎļþ´æ·Å·¾¶
......
If the SQL data type is 'timestamp', we need to use ResultSet.getBytes() to retrieve its value. If the SQL data type is 'datetime', we can use ResultSet.getTimestamp(). It is said timestamp is interanlly saved as binary data.
try {
Class.forName("com.microsoft. ......
SQLÈÕÆÚʱ¼ä²»ÄÜÔçÓÚ1753Äê
1.¹«ÔªÔªÄêµÄµÚÒ»Ì죬Ҳ¾ÍÊǹ«Ôª1Äê1ÔÂ1ÈÕ£¬ÄÇÌìÊÇÐÇÆÚÁù¡£
2.
ÏÖÐеĹ«ÀúÊǸñÀû¸êÀïÀú·¨£¬Õâ¸öÀú·¨²¢²»ÊÇÁ¬ÐøµÄ£¬ÖмäȱÉÙÁË11Ìì¡£1752Äê9ÔÂ2ÈյĺóÒ»Ìì²¢²»ÊÇ9ÔÂ3ÈÕ£¬¶øÊÇ9ÔÂ14ÈÕ¡£Ò²¾ÍÊÇ˵£¬´Ó1752Äê9ÔÂ3ÈÕµ½9ÔÂ13ÈÕµÄ11Ìì²¢²»´æÔÚ¡£
&nb ......
SQL±¸·ÝÓ뻹ԾµäÎĵµ
======================================================================
SQL±¸·Ý
======================================================================
----------------------------------------------------------------------
1¡¢SQLÊý¾Ý¿â»Ö¸´Ä£ÐÍ
------------------------------ ......