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™ ÔÊÐíΪ Insert¡¢Update¡¢Delete ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨£¬²»¹ý¶¼ÊÇҪд T-SQL ......
1.Óòéѯ·ÖÎöÆ÷ÖØÃüÃû
exec sp_rename ÔÃû³Æ, ÐÂÃû³Æ
sp_rename ÊÇ SQL Server™ ×Ô´øµÄÒ»¸ö´æ´¢¹ý³Ì£¬ÓÃÓÚ¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐÓû§´´½¨µÄ¶ÔÏóµÄÃû³Æ£¬Èç±íÃû¡¢ÁÐ±í¡¢Ë÷ÒýÃûµÈ¡£
2.ÓÃÆóÒµ¹ÜÀíÆ÷ÖØÃüÃû
ÔÚ±íÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”£¬Ñ¡ÖÐËùÒªÖØÃüÃûµÄ´¥·¢Æ÷£¬Ð޸Ĵ¥·¢Æ÷ ......
--°´Ä³Ò»×ֶηÖ×éÈ¡×î´ó(С)ÖµËùÔÚÐеÄÊý¾Ý
Êý¾ÝÈçÏ£º
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²©´ó¾«ÉÄãÃÇ»áÓõ½µÄ¡£——mAysWINd
Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµ ......