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

´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦




¿Í»§Ãû³Æ
´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦


Êý¾Ý¿â°æ±¾
SQL SERVER 2008


Îļþ´óС
5G


¹ÊÕÏÃèÊö
¿Í»§µÄÓÎÏ··þÎñÆ÷ÓÃSQL SERVER 2008,Êý¾Ý¿â²»Ã÷Ô­Òò±¨´íÎó,˵ÎÞ·¨·ÃÎÊ,¿Í»§¶ÔʵʱÊý¾Ý¿âÎļþ½øÐÐÁ˸´ÖÆ,×Ô¼ºÓÃÁËN¶à·½·¨½øÐÐÐÞ¸´,Ó²ÅÌÊý¾Ý»Ö¸´,¶¼Î´³É¹¦,×îºóÕÒµ½ÎÒÃÇ,ÉòÑô¿­ÎÄÊý¾Ý»Ö¸´ÖÐÐijɹ¦½«Æä100%ÐÞ¸´³É¹¦.


Êý¾ÝËð»µÔ­Òò
²»Ïê


½â¾ö·½°¸
ÉòÑô¿­Îľ­¹ýçÇÃÜ·ÖÎö,²ÉÓÃרҵËã·¨³É¹¦½«¿Í»§Êý¾Ý¿âÐÞ¸´,µÃµ½¿Í»§ºÃÆÀ.


ÐÞ¸´½á¹û
100%»Ö¸´,Êܵ½¿Í»§ºÃÆÀ.


»Ö¸´ËùÓÃʱ¼ä
4Сʱ


±¸     ×¢
¡¡
¡¡



Ïà¹ØµÄÖ÷ÌâÎÄÕ£º


µ¤¶«ÊÐÍÁµØÕ÷ÓÃÊÕ¹º´¢±¸ÖÐÐÄ WDÓ²Å̲»ÈÏÅÌ Êý¾Ý»Ö¸´³É¹¦

ÉòÑôÊÐijÓÐÏÞ¹«Ë¾ ½ðµûK3 SQL SERVERÊý¾Ý¿â Êý¾Ý»Ö¸´



Ïà¹ØÎĵµ£º

ÓÃSQLÓï¾ä´´½¨±í&ÓÃSQLÓï¾ä´´½¨Êý¾Ý¿â

Êý¾Ý¿âÖеÄËùÓÐÊý¾Ý´æ´¢ÔÚ±íÖС£Êý¾Ý±í°üÀ¨ÐкÍÁС£Áоö¶¨Á˱íÖÐÊý¾ÝµÄÀàÐÍ¡£Ðаüº¬ÁËʵ¼ÊµÄÊý¾Ý¡£ 
ÀýÈ磬Êý¾Ý¿âpubsÖеıíauthorsÓоŸö×ֶΡ£ÆäÖеÄÒ»¸ö×Ö¶ÎÃûΪΪau_lname£¬Õâ¸ö×ֶα»ÓÃÀ´´æ´¢×÷ÕßµÄÃû×ÖÐÅÏ¢¡£Ã¿´ÎÏòÕâ¸ö±íÖÐÌí¼ÓÐÂ×÷Õßʱ£¬×÷ÕßÃû×־ͱ»Ìí¼Óµ½Õâ¸ö×ֶΣ¬²úÉúÒ»ÌõмǼ¡£ 
ͨ¹ý¶¨Òå×ֶ䪎 ......

±È½ÏOracle SQLÖеÄIN & EXISTS

ÔÚOracle SQLÖÐÈ¡Êý¾ÝʱÓÐʱҪÓõ½in ºÍ exists ÄÇôËûÃÇÓÐÊ²Ã´Çø±ðÄØ£¿
1 ÐÔÄÜÉϵıȽÏ
±ÈÈçSelect * from T1 where x in ( select y from T2 )
Ö´ÐеĹý³ÌÏ൱ÓÚ:
select *
  from t1, ( select distinct y from t2 ) t2
 where t1.x = t2.y;
숦﵀
select * from t1 where exists ( select null fro ......

Êý¾Ý¿â×é¼þ Hxj.Data£¨Æß£© (sqlƪ)

ÉÏÒ»½Ú½²ÊöµÄÊÇɾ³ý²Ù×÷£¬±¾½Ú½«½²ÊöÈçºÎÖ±½ÓÖ´ÐÐsqlÓï¾ä¡£ Ö±½ÓÖ´ÐÐsqlÓï¾äÊÇʹÓÃfromSql·½·¨¡£ DbSession.Default.fromSql("select * from products").ToDataTable();
 
ÕâÑù¿´ÆðÀ´Ç×ÇжàÁ˰ɣ¬Ö±½Ósql¾Í¿ÉÒÔÖ´ÐС£
 
µ±È»Ò²¿ÉÌí¼Ó²ÎÊýµÄ°¡¡£
DbSession.Default.fromSql("select * ......

Oracle Sql LoaderÖÐÎÄ×Ö·ûµ¼ÈëÂÒÂëµÄ½â¾ö·½°¸

·þÎñÆ÷¶Ë×Ö·û¼¯NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
¿ØÖÆÎļþctl:
LOAD DATA
CHARACTERSET ZHS16GBK
INFILE 'c:\test.csv'
APPEND  INTO TABLE stk_al_version
FIELDS TERMINATED BY ","
(org_no,stk_c,version,name)
¼ÓÈëºìÉ«Õâ¶ÎÎÄ×Ö ......

sqlÖÐÑ­»·²åÈë´óÁ¿²âÊÔÊý¾Ý

declare @a int
set @a = 1  
while @a<1000000  
begin
    insert into Test(name) values(@a)  
    set @a = @a + 1  
end ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ