SQL¾µä¶ÌС´úÂëÊÕ¼¯
--SQL Server£º
Select TOP N * from TABLE Order By NewID()
--Access£º
Select TOP N * from TABLE Order By Rnd(ID)
Rnd(ID) ÆäÖеÄIDÊÇ×Ô¶¯±àºÅ×ֶΣ¬¿ÉÒÔÀûÓÃÆäËûÈκÎÊýÖµÀ´Íê³É£¬±ÈÈçÓÃÐÕÃû×Ö¶Î(UserName)
Select TOP N * from TABLE Order BY Rnd(Len(UserName))
--MySql£º
Select * from TABLE Order By Rand() Limit 10
--¿ªÍ·µ½NÌõ¼Ç¼
Select Top N * from ±í
--Nµ½MÌõ¼Ç¼(ÒªÓÐÖ÷Ë÷ÒýID)
Select Top M-N * from ±íWhere ID in (Select Top M ID from ±í) Order by ID Desc
--Ñ¡Ôñ10´Óµ½15µÄ¼Ç¼
select top 5 * from (select top 15 * from table order by id asc) table_±ðÃûorder by id desc
--Nµ½½áβ¼Ç¼
Select Top N * from ±íOrder by ID Desc
--ÏÔʾ×îºó5Ìõ¼Ç¼,µ«ÊÇÏÔʾµÄ˳Ðò±ØÐëΪ5,6,7,8,9,10,¶ø²»ÊÇ10,9,8,7,6,5 ÈçϽâ¾ö·½·¨:
select top 5 from test where id in(select top 5 from test order by id desc) order by id asc
--ͨ¹ýÕâ¸öÎÊÌâÒ²ÄÜ×ܽá³ö4-10Ìõ,5-100ÌõÕâÖÖÏÞ¶¨Ò»¶¨·¶Î§ÄÚµÄsqlÓï¾äµÄд·¨:
select top <Ä©¶ËID-¶¥¶ËID+1> * from <±íÃû> where ID not in(select top <¶¥¶ËID-1>) ID from <±íÃû>)
--ÀýÈç:4-10Ìõ¾ÍÓ¦¸Ãд³É
select top 10-4+1 * from test where id not in(select top 4-1 id from test)
ÉÏһƪ: select top 1 * from [news_table] where [ÐÂÎűêʶÁÐ]<µ±Ç°idºÅ where ......
ÏÂһƪ: select top 1 * from [news_table] where [ÐÂÎűêʶÁÐ]>µ±Ç°idºÅ where ...... order by [ÐÂÎűêʶÁÐ] desc --Á½Ìõ¼Ç¼ÍêÈ«Ïàͬ£¬ÈçºÎɾ³ýÆäÖÐÒ»Ìõ
set rowcount=1
delete from thetablename where id=@duplicate_id--@duplicate_idÎªÖØ¸´ÖµµÄid
--Ä£ºý²éѯ
select * &nbs
Ïà¹ØÎĵµ£º
º¯Êý¼ò½é:¡¡¡¡
·µ»Ø Variant (Long) µÄÖµ£¬±íʾÁ½¸öÖ¸¶¨ÈÕÆÚ¼äµÄʱ¼ä¼ä¸ôÊýÄ¿¡£
º¯ÊýÓï·¨:
¡¡¡¡DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýÓï·¨ÖÐÓÐÏÂÁÐÃüÃû²ÎÊý£º
¡¡¡¡interval ±ØÒª¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÀ´¼ÆËãdate1 ºÍ date2 µÄʱ¼ä²îµÄʱ¼ä¼ ......
ÓÉÓÚÍøÕ¾ÊDZðÈ˵Ä
sql server 2000 ²»Äܵ¼Èë2005 µÄÊý¾Ý¿âÎļþ ÎÒÖ»ºÃ°´ÕÕÊéÉÏÖØÐ½¨Á¢µÄÊý¾Ý¿âÎļþ
È»ºóÔÚvisual studio 2005ÖÐÒ»¸öÒ»¸öµÄ¸´ÖÆ´æ´¢¹ý³Ìµ½sql server 2000
ÕâÑù¾Í²»ÓÃÏÂÔØ sql server 2005 ÁË
Èç¹ûÓÐsql server 2005 µÄ»°Ö®¼ÊÉú³É ½Å±¾¾ÍÒ»ÖÂÐÔµ¼Èë¾ÍokÁË ......
USE [master]
GO
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE
GO
USE [Database_Name]
&nb ......
exists £¨sql ·µ»Ø½á¹û¼¯ÎªÕ棩
not exists (sql ²»·µ»Ø½á¹û¼¯ÎªÕ棩
ÈçÏ£º
±íA
ID NAME
1 A1
2 A2
3 A3
±íB
ID AID NAME
1 1 B1
2 2 B2
3 2 B3
±íAºÍ±íBÊÇ£±¶Ô¶àµÄ¹ØÏµ A.ID => B.AID
......
SQL Server 2008 ¸´ÖÆ ·ÖÇøSWITCHÇåÀíÊý¾Ý
³¡¾°£º
ijÖÖÌØ¶¨ÒµÎñÏ£¬ÎÒÃǵIJ¿·ÖÒµÎñÊý¾Ý¿ÉÄÜÖ»»á±£Áô±È½Ï¶ÌµÄʱ¼ä£¬ÓÃÀ´×öÁÙʱ´¦Àí¡£ÒòΪ¿¼ÂǸ߿ÉÓõÄÌØÐÔ£¬¿ÉÄÜ»áÀûÓÃ
SQL ServerµÄ¸´ÖÆ×é¼þ¸´ÖÆÕâÖÖÊý¾Ýµ½ÁíÍâµÄ ÀàËÆÇ°¶Ë£¬²éѯÖÐÐĵÈÊý¾Ý¿â·þÎñÆ÷£¬´´½¨Ò»¸öÈßÓั±¾¡£¸´ÖÆ×é¼þ±ê¼ÇÊÂÎñÈÕÖ¾£¬×·×ÙËùÓеÄUpdate£¬In ......