ÊÕ¼¯µÄÓÖÒ»µÀÓÐȤµÄSQLÌâ
×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê10ÔÂ15ÈÕ 21:59:51±¾Îijö×Ô ¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦http://blog.csdn.net/inthirties/archive/2009/10/15/4673268.aspx °Ñ´ÎÐò²»¶ÔµÄÁÐÕÒ³öÀ´ ÇëÎÊ ÏÂÃæµÄ±í¸ÃÈçºÎÅÅÐò£¿ÎÒÓÐÏÂÃæµÄ±í¡£´ÎÐòÈçÏ ÆäÖеÚ5¸ö¼Ç¼ºÍµÚ6Ìõ¼Ç¼´ÎÐòµßµ¹ÁË¡£Õâ¸ö±íÊý¾ÝÁ¿±È½Ï´ó¡£ ÓÃʲô·½·¨¿ÉÒÔ¶ÔÕâ¸ö±íÖÐµÄ bÁÐÅÅÐò¡£Ê¹ÆäÄܹ»°´ÕÕÉýÐòÅÅÁС£
a b
1 #1¸ËËþ
2 #2¸ËËþ
3 #3.1¸ËËþ
4 #3.2¸ËËþ
5 #5¸ËËþ
6 #4¸ËËþ
7 #6¸ËËþ
8 #7¸ËËþ
9 #9¸ËËþ
10 #8¸ËËþ
ÏÖÔÚÒª×öµÄÊÂÇé¾ÍÊÇ°Ñ ´ÎÐò²»¶ÔµÄÁÐÕÒ³öÀ´¡£ ²»ÊÇÅÅÐò¡£±ÈÈçÉÏÁÐÖÐbÁеÚ5£¬µÚ6ÁС£µÚ9£¬10´ÎÐò²»¶Ô¡£ ÏÖÔÚÒª°ÑÆäÖеÄÁÐÕÒ³öÀ´¡£
5 #5¸ËËþ
6 #4¸ËËþ
9 #9¸ËËþ
10 #8¸ËËþ
¾ÍÊǰÑÕâÑùµÄÁÐÄܹ»ÕÒ³öÀ´¡£ SQL> with temp as(
2 select 1 a, '#1¸ËËþ' b from dual union all
3 select 2 a, '#2¸ËËþ' b from dual union all
4 select 3 a, '#3.1¸ËËþ' b from dual union all
5 select 4 a, '#3.2¸ËËþ' b from dual union all
6 select 5 a, '#5¸ËËþ' b from dual union all
7 select 6 a, '#4¸ËËþ' b from dual
8 ) select a, b from (select temp.*, row_number() over(order by a asc) a_ord,r
ow_number() over(order by to_number(substr(b, 2, length(b)-3)) asc) b_ord from t
emp) t where t.a_ord <>t.b_ord;
A B
---------- --------
6 #4¸ËËþ
5 #5¸ËËþ
Èç¹ûûÓÐÄǾ䡰ÈýÊ®¶øÁ¢¡±£¬ÈýÊ®ËêµÄÄÐÈËÕý¿ÉÒÔÇáÇáËÉËÉ ×¨ÒµÂÛ̳ http://www.inthirties.com ¼¼Êõ²©¿Í http://blog.csdn.net/inthirties ¸öÈËÕ¾µã http://blog.inthirties.com Oracle Mysql¼¼ÊõÂÛ̳| ´òÔìʵÓõÄOracle Mysql¼¼Êõ½»Á÷Ô°µØ
Ïà¹ØÎĵµ£º
Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ czdImport Dat ......
1 £¬¶ÔÓÚÈÕÆÚ×Ö¶Î×Ö¶Î
access±íʾΪ£º#1981-28-12#
SQLSERVER2000±íʾΪ£º''1981-02-12''
2,SQLÓï¾äÇø±ð£¬select ,update ÔÚ¶Ôµ¥±í²Ù×÷ʱ¶¼²î²»¶à£¬
µ«¶à±í²Ù×÷ʱupdateÓï¾äµÄÇø±ðACCESSÓëSQLSERVERÖеÄUpdateÓï¾ä¶Ô±È:
SQLSERVERÖиüжà±íµÄUpdateÓï¾ä:
Update Tab1
SET a.Name = b.Name
from Tab1 a,Tab2 b
Whe ......
1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......
create proc [dbo].[GenerateDataDictionary] as
begin
--»ñÈ¡Êý¾Ý±íÃû
declare @tableid int
declare mycursor Cursor
for select object_id from sys.objects where type='U' and name<>'dtproperties'
--»ñÈ¡×Ö¶ÎÃû³Æ¡¢±êʶ¡¢×Ö¶ÎÐòºÅ¡¢Õ¼ÓÃ×Ö½ÚÊý¡¢Ð¡ÊýλÊý¡¢ÔÊÐí¿Õµ ......
Èç¹ûÔÚSQL Server
ÀïÐèÒª¶¨Ê±»òÕßÿ¸ôÒ»¶Îʱ¼äÖ´ÐÐij¸ö´æ´¢¹ý³Ì»ò3200×Ö·ûÒÔÄÚµÄSQLÓï¾äʱ,¿ÉÒÔÓùÜÀí->SQL Server´úÀí->×÷ÒµÀ´ÊµÏÖ¡£
¡¡¡¡1¡¢¹ÜÀí->SQL Server´úÀí->×÷Òµ(°´Êó±êÓÒ¼ü)->н¨×÷Òµ->
¡¡¡¡2¡¢Ð½¨×÷ÒµÊôÐÔ(³£¹æ)->Ãû³Æ[×Ô¶¨Òå±¾´Î×÷ÒµµÄÃû³Æ]->Æô
Óõķ½¿òÄÚÊǹ´ºÅ->·ÖÀà´¦¿É ......