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

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¾Í±»ÍêÈ«µÄÐ¶ÔØ¸É¾»ÁË£¬¿ÉÒÔÕý³£ÖØÐ°²×°¡£


Ïà¹ØÎĵµ£º

×¥SQLÖ´ÐÐÓï¾äʱ¼äµÄ½Å±¾

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);
×¢Ò ......

SQL server 2008 ´´½¨Ö÷¼üΪ×ÔÔöÁеıí

ʹÓÃ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 ......

java Annotation Æ´×°SQLÓï¾ä

ÉùÃ÷×Ö¶ÎÓ³Éä
@Target(ElementType.FIELD)  
@Retention(RetentionPolicy.RUNTIME) 
public @interface FiledRef
{
    String fieldName();
}
ÉùÃ÷±íÓ³Éä
@Target(ElementType.TYPE)  
@Retention(RetentionPolicy.RUNTIME)
public @interface TableRef
{
 & ......

Ôõô´Óoracleͨ¹ýodbc ºÍsqlµÃµ½mysql

 oracleµÄodbcÍø¹Ø£¨gateway£©¼¸ºõÌṩһ¸öÎÞÏßµÄÊý¾ÝÕûºÏƽ̨£¬ÔÚoracleºÍÆäËüRDBMSÖ®¼ä£¬ÎÒÔÚÕâ²»Ïë˵ËüµÄ£¬²Ù×÷£¬ÏÞÖÆÒÔ¼°Ïà¹ØÐÔ£¬Ëü½â¾öÁËÒ»¸öСÎÊÌ⣬°ÑËü½¨Á¢ÆðÀ´ÄãÄÜ£¬ÀýÈ磬´´½¨Ò»¸ö database link ÔÚoracle ºÍoracleÖ®¼ä£¬±Ï¾¹£¬ÕâÑù²»ÊǺܺÃô£¬ÀýÈçÄãÄÜÔËÐÐÏÂÃæµÄsqlÓï¾ä£¬
select o.col1, m.col1 from or ......

sqlÌæ»»Óï¾ä

--·Ö½â×Ö·û´®°üº¬µÄÐÅÏ¢ÖµºóÈ»ºóºÏ²¢µ½ÁíÍâÒ»±íµÄÐÅÏ¢
--(°®Ð¾õÂÞ.ع»ª(Ê®°ËÄê·çÓê,ÊØµÃ±ùɽѩÁ«»¨¿ª)  2007-12-23  ¹ã¶«ÉîÛÚ)
/*ÎÊÌâÃèÊö
tba
ID  classid   name
1     1,2,3   Î÷·þ
2     2,3     ÖÐɽװ
3&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ