´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦
¿Í»§Ãû³Æ
´óÁ¬Ä³ÍøÂçÓÎÏ··þÎñÆ÷ £¨SQL SERVER 2008£© ÐÞ¸´³É¹¦
Êý¾Ý¿â°æ±¾
SQL SERVER 2008
Îļþ´óС
5G
¹ÊÕÏÃèÊö
¿Í»§µÄÓÎÏ··þÎñÆ÷ÓÃSQL SERVER 2008,Êý¾Ý¿â²»Ã÷ÔÒò±¨´íÎó,˵ÎÞ·¨·ÃÎÊ,¿Í»§¶ÔʵʱÊý¾Ý¿âÎļþ½øÐÐÁ˸´ÖÆ,×Ô¼ºÓÃÁËN¶à·½·¨½øÐÐÐÞ¸´,Ó²ÅÌÊý¾Ý»Ö¸´,¶¼Î´³É¹¦,×îºóÕÒµ½ÎÒÃÇ,ÉòÑô¿ÎÄÊý¾Ý»Ö¸´ÖÐÐijɹ¦½«Æä100%ÐÞ¸´³É¹¦.
Êý¾ÝËð»µÔÒò
²»Ïê
½â¾ö·½°¸
ÉòÑô¿Îľ¹ýçÇÃÜ·ÖÎö,²ÉÓÃרҵËã·¨³É¹¦½«¿Í»§Êý¾Ý¿âÐÞ¸´,µÃµ½¿Í»§ºÃÆÀ.
ÐÞ¸´½á¹û
100%»Ö¸´,Êܵ½¿Í»§ºÃÆÀ.
»Ö¸´ËùÓÃʱ¼ä
4Сʱ
±¸ ×¢
¡¡
¡¡
Ïà¹ØµÄÖ÷ÌâÎÄÕ£º
µ¤¶«ÊÐÍÁµØÕ÷ÓÃÊÕ¹º´¢±¸ÖÐÐÄ WDÓ²Å̲»ÈÏÅÌ Êý¾Ý»Ö¸´³É¹¦
ÉòÑôÊÐijÓÐÏÞ¹«Ë¾ ½ðµûK3 SQL SERVERÊý¾Ý¿â Êý¾Ý»Ö¸´
Ïà¹ØÎĵµ£º
Êý¾Ý¿âÖеÄËùÓÐÊý¾Ý´æ´¢ÔÚ±íÖС£Êý¾Ý±í°üÀ¨ÐкÍÁС£Áоö¶¨Á˱íÖÐÊý¾ÝµÄÀàÐÍ¡£Ðаüº¬ÁËʵ¼ÊµÄÊý¾Ý¡£
ÀýÈ磬Êý¾Ý¿âpubsÖеıíauthorsÓоŸö×ֶΡ£ÆäÖеÄÒ»¸ö×Ö¶ÎÃûΪΪau_lname£¬Õâ¸ö×ֶα»ÓÃÀ´´æ´¢×÷ÕßµÄÃû×ÖÐÅÏ¢¡£Ã¿´ÎÏòÕâ¸ö±íÖÐÌí¼ÓÐÂ×÷Õßʱ£¬×÷ÕßÃû×־ͱ»Ìí¼Óµ½Õâ¸ö×ֶΣ¬²úÉúÒ»ÌõмǼ¡£
ͨ¹ý¶¨Òå×ֶ䪎 ......
ÔÚ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 ......
ÉÏÒ»½Ú½²ÊöµÄÊÇɾ³ý²Ù×÷£¬±¾½Ú½«½²ÊöÈçºÎÖ±½ÓÖ´ÐÐsqlÓï¾ä¡£ Ö±½ÓÖ´ÐÐsqlÓï¾äÊÇʹÓÃfromSql·½·¨¡£ DbSession.Default.fromSql("select * from products").ToDataTable();
ÕâÑù¿´ÆðÀ´Ç×ÇжàÁ˰ɣ¬Ö±½Ósql¾Í¿ÉÒÔÖ´ÐС£
µ±È»Ò²¿ÉÌí¼Ó²ÎÊýµÄ°¡¡£
DbSession.Default.fromSql("select * ......
·þÎñÆ÷¶Ë×Ö·û¼¯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)
¼ÓÈëºìÉ«Õâ¶ÎÎÄ×Ö ......
declare @a int
set @a = 1
while @a<1000000
begin
insert into Test(name) values(@a)
set @a = @a + 1
end ......