SQL Server 2005ÍêÈ«Ð¶ÔØ
SQL Server 2005µÄÐ¶ÔØÊÇÒ»¸ö·Ç³£Í·ÌÛµÄÎÊÌâ¡£ÎÒÔø¾³¢ÊÔ¹ýÖ±½ÓʹÓá¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ßÐ¶ÔØ¡¢Çå³ý°²×°Ä¿Â¼¡¢É¾³ý×¢²á±íÄÚÈݵȵȸ÷ÖÖ·½Ê½×ÛºÏÐ¶ÔØ£¬ÃãÇ¿³É¹¦¡£ÏÖÔÚÖÕÓÚÕÒµ½ÁËÒ»¸öʰ빦±¶µÄ·½·¨£¬¶à´Î³¢ÊÔ£¬Î´ÓÐʧ°Ü,¾ßÌåÈçÏÂ:
1.ÏÂÔØÐ¶ÔØ¹¤¾ß£¬ÓÐÁ½ÖÖ£º
µÚÒ»ÖÖÊÇ΢Èí¹Ù·½ÌṩµÄ¹¤¾ß(msicuu2.exe)
http://support.microsoft.com/default.aspx?kbid=290301
µÚ¶þÖÖÊǸ÷´óÏÂÔØÍøÕ¾ÏÂÔØµÄ·Ç΢Èí¹Ù·½¹¤¾ß(SrvInstw.exe)
΢Èí¹Ù·½¹¤¾ßÐèÒª°²×°£¬¶øÇÒ°²×°²½Öè±È½ÏÂé·³£¬»¹ÓÐûÕÒµ½Ö§³Ö64λµÄ£»
·Ç΢Èí¹Ù·½¹¤¾ß´¿ÂÌÉ«£¬²»Ðè°²×°£¬Ö±½ÓÐ¶ÔØ£¬Ö§³Ö64λ¡£
±¾È˾õµÃ΢Èí×Ô´øµÄ±È½Ï·½±ã£¬¿ÉÒÔÅúÁ¿Ñ¡Ôñ²¢Ð¶ÔØ£¬Ò²ËƺõÐ¶ÔØµÄ¸ü³¹µ×
2.ʹÓÃÐ¶ÔØ¹¤¾ßÐ¶ÔØËùÓÐSQL Server·þÎñºÍÏà¹Ø×é¼þ(×¢Òâ£ºÐ¶ÔØÇ°ÒªÏÈÍ£Ö¹¶ÔÓ¦µÄ·þÎñ£¬·ñÔò¿ÉÄÜÐ¶ÔØÊ§°Ü)
3.ɾ³ýC:\WINDOWS\inf ÏÂËùÓÃÎļþ(ÎÒÊÇÔÚ¸ÃÎļþ¼ÐÏÂËÑË÷“sqlserver”£¬È»ºóɾ³ýËùÓнá¹ûÎļþ)
4.ɾ³ýsql 2005°²×°Ä¿Â¼ÏµÄËùÓÐÎļþ
5.ɾ³ý×¢²á±íÖÐ Microsoft Sql Server ½Ú
6.ʹÓÿØÖÆÃæ°åµÄ¡¾Ìí¼Ó»òɾ³ý³ÌÐò¡¿¹¤¾ß£¬²é¿´ÓÐÎÞÆäËûδɾ³ýµÄSQL Server³ÌÐò£¬ÈçÓж¼Ò»²¢É¾³ýµô
7.ÖØÆô¼ÆËã»ú
¼ÆËã»úÖØÆôÍê³Éºó£¬SQL Server 2005¾Í±»ÍêÈ«µÄÐ¶ÔØ¸É¾»ÁË£¬¿ÉÒÔÕý³£ÖØÐ°²×°¡£
Ïà¹ØÎĵµ£º
select sql_text, spid, v$session.program, process
from v$sqltext, v$session, v$process
where v$sqltext.address = v$session.sql_address
and v$sqltext.hash_value = v$session.sql_hash_value
and v$session.paddr = v$process.addr
and v$process.spid in (4335);
×¢Ò ......
ʹÓÃTranact-SQL ±àд´úÂëÀ´´´½¨Ò»¸öÐÂ±í£º
USE [OnlineJudge]
GO
/****** Object: Table [dbo].[User1] Script Date: 05/17/2010 14:05:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[User2](/*notice convert the tablename*/
[num] [int]IDENTITY(1,1) NOT N ......
ÉùÃ÷×Ö¶ÎÓ³Éä
@Target(ElementType.FIELD)
@Retention(RetentionPolicy.RUNTIME)
public @interface FiledRef
{
String fieldName();
}
ÉùÃ÷±íÓ³Éä
@Target(ElementType.TYPE)
@Retention(RetentionPolicy.RUNTIME)
public @interface TableRef
{
& ......
oracleµÄodbcÍø¹Ø£¨gateway£©¼¸ºõÌṩһ¸öÎÞÏßµÄÊý¾ÝÕûºÏƽ̨£¬ÔÚoracleºÍÆäËüRDBMSÖ®¼ä£¬ÎÒÔÚÕâ²»Ïë˵ËüµÄ£¬²Ù×÷£¬ÏÞÖÆÒÔ¼°Ïà¹ØÐÔ£¬Ëü½â¾öÁËÒ»¸öСÎÊÌ⣬°ÑËü½¨Á¢ÆðÀ´ÄãÄÜ£¬ÀýÈ磬´´½¨Ò»¸ö database link ÔÚoracle ºÍoracleÖ®¼ä£¬±Ï¾¹£¬ÕâÑù²»ÊǺܺÃô£¬ÀýÈçÄãÄÜÔËÐÐÏÂÃæµÄsqlÓï¾ä£¬
select o.col1, m.col1 from or ......
--·Ö½â×Ö·û´®°üº¬µÄÐÅÏ¢ÖµºóÈ»ºóºÏ²¢µ½ÁíÍâÒ»±íµÄÐÅÏ¢
--(°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê,ÊØµÃ±ùɽѩÁ«»¨¿ª) 2007-12-23 ¹ã¶«ÉîÛÚ)
/*ÎÊÌâÃèÊö
tba
ID classid name
1 1,2,3 Î÷·þ
2 2,3 ÖÐɽװ
3&n ......