sql ²éѯÖظ´¼Ç¼2
========µÚһƪ=========
ÔÚÒ»ÕűíÖÐij¸ö×Ö¶ÎÏÂÃæÓÐÖظ´¼Ç¼£¬Óкܶ෽·¨£¬µ«ÊÇÓÐÒ»¸ö·½·¨£¬ÊDZȽϸßЧµÄ£¬ÈçÏÂÓï¾ä£º
select data_guid from adam_entity_datas a where a.rowid > (select min(b.rowid) from adam_entity_datas b where b.data_guid = a.data_guid)
Èç¹û±íÖÐÓдóÁ¿Êý¾Ý£¬µ«ÊÇÖظ´Êý¾Ý±È½ÏÉÙ£¬ÄÇô¿ÉÒÔÓÃÏÂÃæµÄÓï¾äÌá¸ßЧÂÊ
select data_guid from adam_entity_datas where data_guid in (select data_guid from adam_entity_datas group by data_guid having count(*) > 1)
´Ë·½·¨²éѯ³öËùÓÐÖظ´¼Ç¼ÁË£¬Ò²¾ÍÊÇ˵£¬Ö»ÒªÊÇÖظ´µÄ¾ÍÑ¡³öÀ´£¬ÏÂÃæµÄÓï¾äÒ²Ðí¸ü¸ßЧ
select data_guid from adam_entity_datas where rowid in (select rid from (select rowid rid,row_number()over(partition by data_guid order by rowid) m from adam_entity_datas) where m <> 1)
Ä¿Ç°Ö»ÖªµÀÕâÈýÖֱȽÏÓÐЧµÄ·½·¨¡£
µÚÒ»ÖÖ·½·¨±È½ÏºÃÀí½â£¬µ«ÊÇ×îÂý£¬µÚ¶þÖÖ·½·¨×î¿ì£¬µ«ÊÇÑ¡³öÀ´µÄ¼Ç¼ÊÇËùÓÐÖظ´µÄ¼Ç¼£¬¶ø²»ÊÇÒ»¸öÖظ´¼Ç¼µÄÁÐ±í£¬µÚÈýÖÖ·½·¨£¬ÎÒÈÏΪ×îºÃ¡£
========µÚ¶þƪ=========
select usercode,count(*) from ptype group by usercode having count(*) >1
========µÚÈýƪ=========
ÕÒ³öÖظ´¼Ç¼µÄID:
select ID from
( select ID ,count(*) as Cnt
from ÒªÏû³ýÖظ´µÄ±í
group by ID
) T1
where T1.cnt>1
ɾ³ýÊý¾Ý¿âÖÐÖظ´Êý¾ÝµÄ¼¸¸ö·½·¨
Êý¾Ý¿âµÄʹÓùý³ÌÖÐÓÉÓÚ³ÌÐò·½ÃæµÄÎÊÌâÓÐʱºò»áÅöµ½Öظ´Êý¾Ý£¬Öظ´Êý¾Ýµ¼ÖÂÁËÊý¾Ý¿â²¿·ÖÉèÖò»ÄÜÕýÈ·ÉèÖÃ……
·½·¨Ò»
declare @max integer,@id integer
declare cur_rows cursor local for select Ö÷×Ö¶Î,count(*) from
±íÃû group by Ö÷×ֶΠhaving cou
Ïà¹ØÎĵµ£º
LIKEºÍͨÅä·û
©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥©¥
È·¶¨¸ø¶¨µÄ×Ö·û´®ÊÇ·ñÓëÖ¸¶¨µÄģʽƥÅ䡣ģʽ¿ÉÒÔ°üº¬³£¹æ×Ö·ûºÍͨÅä·û×Ö·û¡£Ä£Ê½Æ¥Åä¹ý³ÌÖУ¬³£¹æ×Ö·û±ØÐëÓë×Ö·û´®ÖÐÖ¸¶¨µÄ×Ö·ûÍêÈ«Æ¥Å䡣Ȼ¶ø£¬¿ÉʹÓÃ×Ö·û´®µÄÈÎÒâƬ¶ÎÆ¥ÅäͨÅä·û¡£ÓëʹÓÃ
= ºÍ != ×Ö·û´®±È½ÏÔËËã·ûÏà±È£¬Ê¹ÓÃͨÅä·û¿Éʹ LIKE ÔËË ......
ÆäʵÔÚÐÞ¸ÄÊý¾Ý¿âÃû³Æ֮ǰ£¬Èç¹ûÓÐÓû§Á¬½Óµ½Êý¾Ý¿âµÄ»°»áÔì³ÉÊý¾Ý¿âÖØÃüÃûʧ°Ü£¬¿ÉÒÔÏÈÖ´ÐÐ
select spid
from master.dbo.sysprocesses
where dbid=db_id('OldDbName')
½á¹û¼¯ÖÐÏÔʾµÄÊǵ±Ç°Á¬½Óµ½Êý¾Ý¿âOldDbNameµÄÁ¬½Ó
±ÈÈç½á¹ûÊÇ
79
81
µ±È»£¬Êµ¼ÊÖµÓ¦¸Ã²»ÊÇÕâÁ½¸ö
È»ºóÖ´ÐÐ
kill 79
kill 81
¹Ø±ÕÒѽ¨Á¢ ......
ÎÄÕÂÔ´´£¬×ªÔØÇëÓëBlogÖ÷ÈËÁªÏµ£¬robin9257@hotmail.com
JAVAÓëSQLÇŽӵÄÓÅȱµã£º
1¡¢Óŵ㣺²»ÓÃÏÂÔØÇý¶¯³ÌÐò£¬ÔÊÐíÓÃÏàͬ´úÂë·ÃÎʲ»Í¬DBMS¡£
2¡¢È±µã£ºÐ§Âʵ͡£
¾³£³öÏֵı¨´íµã£º
1¡¢java.sql.SQLException: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò
&nbs ......
bit£º0»ò1µÄÕûÐÍÊý×Ö
int£º´Ó-2^31(-2,147,483,648)µ½2^31(2,147,483,647)µÄÕûÐÍÊý×Ö
smallint£º´Ó-2^15(-32,768)µ½2^15(32,767)µÄÕûÐÍÊý×Ö
tinyint£º´Ó0µ½255µÄÕûÐÍÊý×Ö
decimal£º´Ó-10^38µ½10^38-1µÄ¶¨¾«¶ÈÓëÓÐЧλÊýµÄÊý×Ö
numeric£ºdecimalµÄͬÒå´Ê
money£º´Ó-2^63(-922,337,203,685,477.580 ......