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

sql²éÕÒÖØ¸´Êý¾Ý

1.²éÕÒÖØ¸´Êý¾Ý±íµÄidÒÔ¼°Öظ´Êý¾ÝµÄÌõÊý
select max(id) as nid,count(id) as ÖØ¸´ÌõÊý from tableName
group by linkname Having Count(*) > 1
2.²éÕÒÖØ¸´Êý¾Ý±íµÄÖ÷¼ü
select max(id) as nid from tableName
group by linkname  Having Count(id) > 1
3.ɾ³ýÖØ¸´µÄÊý¾Ý
delete from tableName
where id in (
select max(id) as nid from tableName
group by linkname  Having Count(id) > 1
)


Ïà¹ØÎĵµ£º

SQL server´¥·¢Æ÷ÈëÃÅ1 ´´½¨Ò»¸ö¼òµ¥µÄ´¥·¢Æ÷

´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server™ ÔÊÐíΪ Insert¡¢Update¡¢Delete ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨£¬²»¹ý¶¼ÊÇҪд T-SQL ......

SQL server´¥·¢Æ÷ÈëÃÅ2 ÖØÃüÃû´¥·¢Æ÷


1.Óòéѯ·ÖÎöÆ÷ÖØÃüÃû
exec sp_rename Ô­Ãû³Æ, ÐÂÃû³Æ
sp_rename ÊÇ SQL Server™ ×Ô´øµÄÒ»¸ö´æ´¢¹ý³Ì£¬ÓÃÓÚ¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐÓû§´´½¨µÄ¶ÔÏóµÄÃû³Æ£¬Èç±íÃû¡¢ÁÐ±í¡¢Ë÷ÒýÃûµÈ¡£
2.ÓÃÆóÒµ¹ÜÀíÆ÷ÖØÃüÃû
ÔÚ±íÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”£¬Ñ¡ÖÐËùÒªÖØÃüÃûµÄ´¥·¢Æ÷£¬Ð޸Ĵ¥·¢Æ÷ ......

[ת]sql·Ö×éͳ¼Æ

--°´Ä³Ò»×ֶηÖ×éÈ¡×î´ó(С)ÖµËùÔÚÐеÄÊý¾Ý   
Êý¾ÝÈçÏ£º
name val memo
a    2   a2(aµÄµÚ¶þ¸öÖµ)
a    1   a1--aµÄµÚÒ»¸öÖµ
a    3   a3:aµÄµÚÈý¸öÖµ
b    1   b1--bµÄµÚÒ»¸öÖµ
b &n ......

SQL Server 2008¼òÌåÖÐÎÄÆóÒµ°æ(¸½ÐòÁкÅ)

SQL Server 2008ÆóÒµ°æ. SQL Server 2008ÆóÒµ°æÊÇÒ»¸öÈ«ÃæµÄÊý¾Ý¹ÜÀíºÍÒµÎñÖÇÄÜÆ½Ì¨£¬Îª¹Ø¼üÒµÎñÓ¦ÓÃÌṩÁËÆóÒµ¼¶µÄ¿ÉÀ©Õ¹ÐÔ¡¢Êý¾Ý²Ö¿â¡¢°²È«¡¢¸ß¼¶·ÖÎöºÍ±¨±íÖ§³Ö¡£ÕâÒ»°æ±¾½«ÎªÄãÌṩ¸ü¼Ó¼á¹ÌµÄ·þÎñÆ÷ºÍÖ´Ðдó¹æÄ£ÔÚÏßÊÂÎñ´¦Àí¡£
SQL Server 2008±ê×¼°æ. SQL Server 2008±ê×¼°æÊÇÒ»¸öÍêÕûµÄÊý¾Ý¹ÜÀíºÍÒµÎñÖÇÄÜÆ½Ì¨£¬Îª²¿ ......

Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä


×ªÔØËµÃ÷£º¸øÕýÔÚ×öϵͳºÍÏë×öϵͳµÄÈË£¬SQL²©´ó¾«ÉÄãÃÇ»áÓõ½µÄ¡£——mAysWINd
Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ