¹ØÓÚ sql server ÊÓͼ
Ôø¾ÓÐÏëͨ¹ý´´½¨sql serverÊÓͼµ÷ÕûÓ¦ÓÃÐÔÄܵÄÏë·¨£¬²»¹ýºóÀ´Ö¤Ã÷Õâ¸öÏë·¨ÊÇÐв»Í¨µÄ¡£
×öÁ˸öʵÑ飬ÔÚ¶ÔÔÀ´µÄsqlÓï¾äµ÷ÕûÖ®ºó´´½¨ÁËÁ½¸öÊÓͼ£¬°ÑÔÀ´µÄsqlת»»ÎªÊÓͼÁË£¬Í¨¹ýÊÓͼÀ´¶ÁÈ¡Êý¾Ý¡£×îÖյıȽϽá¹ûÊÇͨ¹ýÊÓͼ±ÈÖ±½ÓʹÓÃsqlÓï¾äÒªÂý£¬Í¨¹ýÊÓͼÀ´Ìá¸ßsqlµÄÐÔÄÜ¿´À´ÊDz»ÐС£
ÁªÏëÆðÈ¥Äêij¸ö¹«Ë¾¸øÎÒÃÇ×öµÄ³ÌÐòsql·ÖÎö£¬¿´À´ÀïÃæÓÐЩ¶«Î÷¾ÍÊdzàÂãÂãµÄÃÉÈ˵ġ£
Ïà¹ØÎĵµ£º
Ò». ²éÕÒÖظ´¼Ç¼
1. ²éÕÒÈ«²¿Öظ´¼Ç¼
Select * from ±í Where Öظ´×ֶΠIn (Select Öظ´×Ö¶Î
from ±í Group By Öظ´×ֶΠHaving Count(*)>1)
2. ¹ýÂËÖظ´¼Ç¼(Ö»ÏÔʾһÌõ)
Select * from HZT Where ID In (Select Max(ID) from HZT Group By Title)
×¢£º´Ë´¦ÏÔʾID×î´óÒ»Ìõ¼Ç¼
¶þ. ɾ³ýÖظ´¼Ç ......
ÊÓͼ¿ÉÒÔ±»¿´³ÉÊÇÐéÄâ±í»ò´æ´¢²éѯ¡£¿Éͨ¹ýÊÓͼ·ÃÎʵÄÊý¾Ý²»×÷Ϊ¶ÀÌصĶÔÏó´æ´¢ÔÚÊý¾Ý¿âÄÚ¡£Êý¾Ý¿âÄÚ´æ´¢µÄÊÇ SELECT Óï¾ä¡£SELECT Óï¾äµÄ½á¹û¼¯¹¹³ÉÊÓͼËù·µ»ØµÄÐéÄâ±í¡£Óû§¿ÉÒÔÓÃÒýÓñíʱËùʹÓõķ½·¨£¬ÔÚ Transact-SQL Óï¾äÖÐͨ¹ýÒýÓÃÊÓͼÃû³ÆÀ´Ê¹ÓÃÐéÄâ±í¡£Ê¹ÓÃÊÓͼ¿ÉÒÔʵÏÖÏÂÁÐÈÎÒ»»òËùÓй¦ÄÜ£º
½«Óû§ÏÞ¶¨ÔÚ± ......
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
fr ......
create PROCEDURE [dbo].[AllDnn_NewsPublish_DeleteArticleByArticle]
@ArticleID nvarchar(200)
AS
declare @sql nvarchar(1000)
set @sql='DELETE dbo.Site_News_Article where ArticleID in ('+@ArticleID+')'
exec (@sql)
--[AllDnn_NewsPublish_DeleteArticleByArticle] '50,51' ......
1¡£°æ±¾£ºSql2008/2005
2¡£Ä¿µÄ£ºµ¼³öÖ¸¶¨µÄ±íÖÐËùÓÐÊý¾Ý£¬µ¼³ö¸ñʽΪ insert Óï¾ä
3¡£¾ßÌå²Ù×÷£º
1£©ÕÒµ½ÐèÒªµ¼³öµÄÊý¾Ý¿â£¬ÓÒ¼ü²Ëµ¥£¬ÈÎÎñ--¡µÉú³É½Å±¾
2£©½øÈëÏòµ¼£¬Ò»Â·ÏÂÒ»²½£¬×¢ÒâÑ¡ÔñÉú³É½Å±¾Ñ¡ÏîµÄʱºò£¬½«“±àдÊý¾ÝµÄ½Å±¾”ÉèÖÃΪ“True”¼´¿É
3£©±£´æÉú³ÉµÄSqlÎļþ ......