Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLС¶Ì¾äÊÕ¼¯

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 *  from product&n


Ïà¹ØÎĵµ£º

¼¸¸ö³£Óõģ¬¶Ô±íµÄijһÁнøÐвÙ×÷µÄSQLÃüÁî

ÊÊÓãºORACLE
 ÐÞ¸ÄÁÐÃû
          alter table xxx rename column aaa to bbb;
ɾ³ýÒ»ÁÐ
          alter table xxx drop column aaa;
Ôö¼ÓÒ»ÁÐ
          alter ......

SQL SERVER convertº¯ÊýÈÕÆÚ¸ñʽ»¯Ó¦ÓÃ

Sql Server ÖÐÒ»¸ö·Ç³£Ç¿´óµÄÈÕÆÚ¸ñʽ»¯º¯Êý
Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GE ......

Ó°ÏìSQL serverÐÔÄܵĹؼüÈý¸ö·½Ãæ

1 Âß¼­Êý¾Ý¿âºÍ±íµÄÉè¼Æ
Êý¾Ý¿âµÄÂß¼­Éè¼Æ¡¢°üÀ¨±íÓë±íÖ®¼äµÄ¹ØϵÊÇÓÅ»¯¹ØϵÐÍÊý¾Ý¿âÐÔÄܵĺËÐÄ¡£Ò»¸öºÃµÄÂß¼­Êý¾Ý¿âÉè¼Æ¿ÉÒÔΪ
ÓÅ»¯Êý¾Ý¿âºÍÓ¦ÓóÌÐò´òÏÂÁ¼ºÃµÄ»ù´¡¡£
±ê×¼»¯µÄÊý¾Ý¿âÂß¼­Éè¼Æ°üÀ¨ÓöàµÄ¡¢ÓÐÏ໥¹ØϵµÄÕ­±íÀ´´úÌæºÜ¶àÁеij¤Êý¾Ý±í¡£ÏÂÃæÊÇһЩʹÓñê×¼»¯
±íµÄһЩºÃ´¦¡£
A:ÓÉÓÚ±íÕ­£¬Òò´Ë¿ÉÒÔʹŠ......

SQLÊý¾Ý¿â¿ìÕÕ


Êý¾Ý¿â¿ìÕÕÊÇMSSQL2005µÄй¦ÄÜ£¬½öÔÚ Microsoft SQL Server 2005 Enterprise Edition ÖпÉÓ᣶øÇÒSQL Server Management Studio ²»Ö§³Ö´´½¨Êý¾Ý¿â¿ìÕÕ£¬´´½¨¿ìÕÕµÄΨһ·½Ê½ÊÇʹÓà Transact-SQL¡£
Êý¾Ý¿â¿ìÕÕÊÇÊý¾Ý¿â£¨³ÆΪ“Ô´Êý¾Ý¿â”£©µÄÖ»¶Á¾²Ì¬ÊÓͼ¡£ÔÚ´´½¨Ê±£¬Ã¿¸öÊý¾Ý¿â¿ìÕÕÔÚÊÂÎñÉ϶¼ÓëÔ´Êý¾Ý¿âÒ»Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ