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

ACCESSºÍMSSQL ÈçºÎËæ»ú¶ÁÈ¡Êý¾Ý¿â¼Ç¼

²éѯÓï¾äÖ»ÒªÕâÑùд,¾Í¿ÉÒÔËæ»úÈ¡³ö¼Ç¼ÁË
SQL="Select top 6 * from Dv_bbs1 where isbest = 1 and layer = 1 order by newID() desc"
ÔÚACCESSÀï
SELECT top 15 id from tablename order by rnd(id)
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
SQLÊý¾Ý¿âÓиönewidº¯Êý£¬¿ÉÒԺܷ½±ãµÄÓÃSQLÓï¾äµÃµ½±íÖеÄËæ»úÊý¾Ý¡£µ«accessÊý¾Ý¿âûÕâô·½±ã£¬ËäÈ»ÓиöRnd£¬¿ÉÒÔͨ¹ý“select top 10 * from tb order by rnd(id)”µÃµ½Ëæ»úÊý¾Ý£¬¿ÉϧÔÚVBÖÐʹÓ㬲úÉúµÄËæ»úÐòÁÐÊÇÒ»ÑùµÄ¡£
ÓÐÈË˵ÔÚ³ÌÐòÖмÓÉÏRandomize³õʼ»¯Ëæ»úÖÖ×Ó£¬ÄÇôÕâֻ˵¶ÔÁËÒ»°ë£¬ÔÚ³ÌÐòÖмòµ¥µÄ¼ÓÉÏRandomize£¬ÊÇû×÷Óõģ¬µÀÀíºÜ¼òµ¥£¬Randomize²»¿ÉÄÜÓ°ÏìSQLÓï¾äÖеÄrnd,ÄÇÖ»²»¹ýÊǸö×Ö·û´®£¬SQLÓï¾äÊǷŵ½jetÖÐÈ¥Ö´Ðеġ£
ǰЩÌìÔÚÂÛ̳ÉÏ¿´µ½ÓÐÈË˵ÓÃtime£¬ÄÇôֻÓÃrnd(time)ÕâÑùÊDz»Ðеģ¬rndÖбØÐëÒª°üº¬±íÖеÄÒ»¸ö×Ö¶Î(ÈÎÒâ×ֶΣ¬µ±È»ÊÇÖ÷¼üЧ¹û¸üºÃ)£¬²âÊÔÏÂÀ´£¬rnd(time+id)ÕâÑùÒÀÈ»²»ÐÐ! ²»¹ý·Ç³£ÒâÍâµÄÊÇrnd(time-id)È´³É¹¦ÁË¡£ÎªÊ²Ã´ËµÒâÍ⣬°´ÎÒµÄÀí½â£¬timeÔÚÓëÊýÖµ×öÔËËãʱ£¬»áת»»³ÉÒ»¸öСÓÚ1µÄdouble£¬ÕâÑùÓëID£¨´óÓÚ1µÄÕýÖµ£©×ö¼õÔËËãµÄ½á¹û±ØÈ»ÊÇÒ»¸ö¸ºÊý£¬ÎÒÃÇÖªµÀrndÈç¹ûÓÃÁ˸ºÊýÖÖ×Ó£¬»á²úÉúÏàͬµÄËæ»úÐòÁУ¬ÕâÊÇÎļþ¼Ó½âÃÜËã·¨Öг£Óõ½µÄ·½·¨£¬¿ÉÔÚÕâ¶ùÈ´Äܵõ½ÕýÈ·µÄ½á¹û£¬µ½ÏÖÔÚҲûÏëͨ......
½ÓÏÂÈ¥£¬ÓÃrnd(time-id)¼ÌÐø²âÊÔÄã»á·¢ÏÖ£¬Á¬Ðø¿ìËٵزéѯÏ£¬»áÓÐÎÊÌ⣬»á³öÏÖ¶þ´Î»òÈý´Î²éѯ½á¹ûÒ»ÑùµÄÎÊÌâ¡£·ÖÎöһϿÉÒÔÕÒµ½Ô­Òò£¬rnd(number)ÖеÄnumberÊǸösingle£¬ÕâÑùËü»á½Ø¶Ïtime-idÕâ¸öÔËËã½á¹ûdoubleºóÃæÊý×Ö£¬ÕâÑù¿ìËÙ²éѯʱnumberÕâ¸öֵû¸Ä±ä£¬ËùÒÔ²éѯ½á¹ûҲûÓиı䡣


Ïà¹ØÎĵµ£º

mssql Öн«ºº×Öת»»ÎªÆ´ÒôÊ××Öĸ·½·¨


1.
--½«ºº×Öת»»ÎªÆ´ÒôÊ××Öĸ
CREATE   function   GetAllPY(@str   nvarchar(4000))
returns   nvarchar(4000)
--WITH   ENCRYPTION
as
begin
declare   @intLen int
declare   @strRet nvarchar(4000)
declare   @temp   nvarchar(100)
set   @intLen &nb ......

½â¾öFailed to access IIS metabase


Ô­Òò£ºIISûÓÐ×¢²á
½â¾ö°ì·¨£º
·½·¨Ò»£º
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ±Ç°Óû§£©
2¡¢aspnet_regiis -i £¨×¢²áIIS£©
3¡¢iisreset /noforce £¨ÖØÆôIIS£©
 
²Ù×÷Ïêϸ£º
C:\Documents and Settings\ ......

ASP.NETʵÏÖÔöɾ¸Ä²éµÈ¹¦ÄÜ(Access°æ)ϵͳ֮ËÄ É¾³ý

//¸ù¾ÝÖ÷¼üÀ´É¾³ý±íÖеÄÊý¾Ý¡£
//ɾ³ý
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        OleDbConnection sqlConnection = new OleDbConnection(GetConnection());
 
   & ......

MSSQLÊý¾Ý¿âÖз¢ÏÖD99_tmp±íµÄ´¦Àí·½·¨

ÏàÐźܶàASP+MSSQLµÄÍøÕ¾¶¼Óб»ÈË×¢Èë¹ýµÄ¾­Àú£¬Êý¾Ý¿â±íÖжàÁËһЩ±í£¬ÀàËÆÒÔϵıíD99_tmp,D99_cmd£¬kill_kk¡£
D99_tmp£¨subdirectory,depth,fileÈý¸ö×ֶΣ¬ÀïÃæµÄÊý¾Ý¶¼ÊÇÍøÕ¾ÎļþºÍĿ¼£©
MSSQLÊý¾Ý¿â´æÔÚ¼¸¸öΣÏÕµÄÀ©Õ¹´æ´¢¹ý³Ì£¬Ä¬ÈÏPublic×é¿ÉÖ´ÐÐȨÏÞ£¬SQL×¢ÈëÕß¿ÉÀûÓô˶ÁÈ¡ÎļþĿ¼¼°Óû§×飬²¢¿Éͨ¹ýÏÈдÈëÊý¾ ......

¡¾×ª¡¿ACCESSÖÐÈçºÎÔÚSQLÓï¾äµÄWHEREÌõ¼þÖмÓÈÕÆÚÌõ¼þ

ת×Ô
http://topic.csdn.net/t/20050110/09/3711952.html
accessÖÐʱ¼äÒªÓÃ#,²»ÊÇË«ÒýºÅ  
  select   *   from   kc   where   rq   <   #2000-01-01#   and   rq>#2002-01-01#  
  ²»ÒªÓÃbetween,ËüµÄЧÂÊÌ©µÍ  
ʹÓÃ# ¶ø²»ÊÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ