sqlÈý±íÁªºÏ²éѯ,count´ÎÊý
sqlÈý±íÁªºÏ²éѯ
a±í£º³Ùµ½¼Ç¼±í---------------------------------------------------------------------------------------------------------------------
ÐÕÃû Ö°¹¤±àºÅ ³Ùµ½ÈÕÆÚ¼Ç¼
ÕÅÈý 001 2009-6-1
Àî˹ 002 2009-6-2
ÕÅÈý 001 2009-6-2
ÍõÎå 003 2009-6-4
ÕÅÈý 001 2009-6-15
Àî˹ 002
Ïà¹ØÎĵµ£º
using System;
using System.Threading;
namespace ConsoleApplication1
{
/// <summary>
/// Class1 µÄժҪ˵Ã÷¡£
/// </summary>
class Class1
{
/// <summary>
/// Ó¦ÓóÌÐòµÄÖ÷Èë¿Úµã¡£
/// </summary>
[STAThread]
& ......
SQL SERVER ·þÎñ
SQL Server Analysis Services £ºÎªÉÌÒµÖÇÄÜÓ¦ÓóÌÐòÌṩÁª»ú·ÖÎö´¦Àí(OLAP)ºÍÊý¾ÝÍÚ¾ò¹¦ÄÜ(ºËÐÄ·þÎñ)¡£
SQL Server Browser£º½« SQL Server Á¬½ÓÐÅÏ¢Ìṩ¸ø¿Í»§¶Ë¼ÆËã»ú
SQL Server FullText Search£º¿ìËÙ´´½¨½á¹¹»¯ºÍ°ë½á¹¹»¯Êý¾ÝµÄÄÚÈݺÍÊôÐÔ
SQL Server VSS Writer£ºÌṩͨ¹ý Windows VSS »ù´¡½á¹¹ ......
×Ó±í²éѯ£¬¸¸±íÒ»¶¨Òª¼Ó±ðÃû£¬·ñÔòÊý¾Ý»áÓÐÎÊÌ⣬²»±¨±àÒë´í
select * from table1 a where exist(select 1 from table2 where a.id=b.id)
´æ´¢¹ý³Ì½á¹û¼¯²åÈëµ½ÏÖÓбí
insert into table1 exec procname args
ÁªºÏÒÑÓÐ±í£¬½ô¸úÔÚºóÃæ£¬¶Ô»ã×ܺÜÓÐÓÃ
select a from table1 union all select 'ºÏ¼Æ'
½á¹û¼¯ÀïµÄij ......
Ò»¡¢¾ßÓÐÖ÷¼üµÄÇé¿ö
I.¾ßÓÐΨһÐÔµÄ×Ö¶Îid(ΪΨһÖ÷¼ü)
delete Óû§±í
where id not in
(
select max(id) from Óû§±í group by col1,col2,col3...
)
group by ×Ó¾äºó¸úµÄ×ֶξÍÊÇÄãÓÃÀ´ÅжÏÖØ¸´µÄÌõ¼þ£¬ÈçÖ»ÓÐcol1£¬
ÄÇôֻҪcol1×Ö¶ÎÄÚÈÝÏàͬ¼´±íʾ¼Ç¼Ïàͬ¡£
II. ......
1 ǰÑÔ
¿Í·þÒµÎñÊܵ½SQLÓï¾äµÄÓ°Ïì·Ç³£´ó£¬ÔÚ¹æÄ£±È½Ï´óµÄ¾Öµã£¬ÍùÍùÒòΪһ¸öСµÄSQLÓï¾ä²»¹»ÓÅ»¯£¬µ¼ÖÂÊý¾Ý¿âÐÔÄܼ±¾çϽµ£¬Ð¡ÐÍ»úidleËùÊ£ÎÞ¼¸£¬Ó¦Ó÷þÎñÆ÷¶ÏÁ¬¡¢³¬Ê±£¬ÑÏÖØÓ°ÏìÒµÎñµÄÕý³£ÔËÐС£Òò´Ë£¬³ÆµÍЧµÄSQLÓï¾äΪ¿Í·þÒµÎñµÄ‘¶ñÁú’²¢²»¹ý·Ö¡£Êý¾Ý¿âµ ......