¼¸µÀ¾µäµÄSQL±ÊÊÔÌâÄ¿
¼¸µÀ¾µäµÄSQL±ÊÊÔÌâÄ¿£¨Óд𰸣©
£¨1£©±íÃû£º¹ºÎïÐÅÏ¢
¹ºÎïÈË ÉÌÆ·Ãû³Æ ÊýÁ¿
A ¼× 2
B ÒÒ 4
C ±û 1
A ¶¡ 2
B ±û 5
……
£¨ÆäËûÓû§ÊµÑéµÄ¼Ç¼´ó¼Ò¿É×ÔÐвåÈ룩
¸ø³öËùÓйºÈëÉÌƷΪÁ½ÖÖ»òÁ½ÖÖÒÔÉϵĹºÎïÈ˼Ǽ
´ð£ºselect * from ¹ºÎïÐÅÏ¢ where ¹ºÎïÈË in (select ¹ºÎïÈË from ¹ºÎïÐÅÏ¢ group by ¹ºÎïÈË having count(*) >= 2);
£¨2£©±íÃû£º³É¼¨±í
ÐÕÃû ¿Î³Ì ·ÖÊý
ÕÅÈý ÓïÎÄ 81
ÕÅÈý Êýѧ 75
ÀîËÄ ÓïÎÄ 56
ÀîËÄ Êýѧ 90
ÍõÎå ÓïÎÄ 81
ÍõÎå Êýѧ 100
ÍõÎå Ó¢Óï 49
……
£¨ÆäËûÓû§ÊµÑéµÄ¼Ç¼´ó¼Ò¿É×ÔÐвåÈ룩
¸ø³ö³É¼¨È«²¿ºÏ¸ñµÄѧÉúÐÅÏ¢£¨°üº¬ÐÕÃû¡¢¿Î³Ì¡¢·ÖÊý£©£¬×¢£º·ÖÊýÔÚ60ÒÔÉÏÆÀΪºÏ¸ñ
´ð£ºselect * from ³É¼¨±í where ÐÕÃû not in (select distinct ÐÕÃû from ³É¼¨±í where ·ÖÊý < 60)
»òÕߣº
select * from ³É¼¨±í where ÐÕÃû in (select ÐÕÃû from ³É¼¨±í group by ÐÕÃû having min(·ÖÊý) >=60)
£¨3£©±íÃû£ºÉÌÆ·±í
Ãû³Æ ²úµØ ½ø¼Û
Æ»¹û ÑĮ̀ 2.5
Æ»¹û ÔÆÄÏ 1.9
Æ»¹û ËÄ´¨
Ïà¹ØÎĵµ£º
{
SqlConnection cnn = new SqlConnection
("context connection=true");
cnn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandText = "select * from customers";
SqlDataReader reader = cmd.ExecuteReader();
SqlContext.Pipe.Send(reader);
reader.Close();
cnn.Close();
}
......
ÍâÁª½Ó:ÍâÁª½Ó¿ÉÒÔÊÇ×óÏòÍâÁª½Ó¡¢ÓÒÏòÍâÁª½Ó»òÍêÕûÍⲿÁª½Ó¡£
ÔÚ from ×Ó¾äÖÐÖ¸¶¨ÍâÁª½Óʱ£¬¿ÉÒÔÓÉÏÂÁм¸×é¹Ø¼ü×ÖÖеÄÒ»×éÖ¸¶¨£º
LEFT JOIN »ò LEFT OUTER JOIN;
×óÏòÍâÁª½ÓµÄ½á¹û¼¯°üÀ ......
×öÏîÄ¿ÀïÃæµÄÊý¾Ý¿âÉè¼ÆÁËÁ½¸öÀàÐÍ·ÅÒ»¸ö×Ö¶ÎÀïÃæ,ÎÒÓÖҪͨ¹ý·Ö¿ªµÄÀàÐÍÀ´½øÐвéѯ,Í´¿à°¡,
Á½ÖÖ·½·¨;
1,¶ÁÈ¡µ½»º´æÖÐ×Ô¶¨Òådatatable, ´úÂë¾Í²»ÌùÁË.
²»ÐÀÉÍÕâÖÖ×ö·¨,ÒòΪÎÒÒѾ°ÑÒ³ÃæÉϺܶණÎ÷дÁË,¶¼ÊÇÓеÄSqlÓï¾ä,ÕâÑù¸Äһ϶¼Òª¸ÄÁË.
2.Ö±½ÓÔÚSqlÀïÃ潨ÊÓͼ,
lÓÃSUBSTRING(dbo.K_ProductDtl.Caizhi, 0, CH ......
ÏÂÔØsql2005ÍêÒÔºó½âѹ³öÀ´£¬´ó¼Ò¿ÉÒÔ¿´µ½cs_sql_2005_chs_x86Õâ¸öĿ¼£¬½øÈëÕâ¸öĿ¼ÔËÐÐsetup.exeÎļþ£¬°²×°³ÌÐò¾Í¿ªÊ¼ÔËÐÐÁË¡£
Ê×Ïȵ¯³öÀ´µÄÊÇÈí¼þÐí¿ÉÌõ¿î
¹´ÉÏÎÒ½Ó°®Ðí¿ÉÌõ¿îºÍÌõ¼þ£¬µãÏÂÒ»²½
ÕâÀïÁгöÁËSQL2005ÔËÐл·¾³£¬Ö±½Óµã°²×°
³ÌÐò¿ªÊ¼°²×°SQL2005ÔËÐбØÐèµÄ»·¾³£¬ÅäÖÃ×é¼þ
±ØÐèµÄ×é¼þ°²×°ºÃÁË£¬µãÏÂÒ»²½¼ ......
SQL Server 2005 ·þÎñÆ÷½ÇÉ«ºÍÊý¾Ý¿â½ÇÉ«ÃûÈ«½â
/*·þÎñÆ÷½ÇÉ«*/
sysadmin
--ÔÚ SQL Server ÖнøÐÐÈκλ¡£¸Ã½ÇÉ«µÄȨÏÞ¿çÔ½ËùÓÐÆäËü¹Ì¶¨·þÎñÆ÷½ÇÉ«¡£
serveradmin
--ÅäÖ÷þÎñÆ÷·¶Î§µÄÉèÖá£
setupadmin
--Ìí¼ÓºÍɾ³ýÁ´½Ó·þÎñÆ÷£¬²¢Ö´ÐÐijЩϵͳ´æ´¢¹ý³Ì£¨Èç sp_serveroption£©¡£
securityadmin
--¹ÜÀí·þÎñÆ÷ ......