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

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µÄÊǵڼ¸Ìõ¼Ç¼µÄ»°
delete from table1 where rowid in 
  (select rd from (
  select rowid rd,rownum rn from table1)
  where rn>=21 and rn<=30)

ѧϰ¡£¡£¡£



delete from table1 where rn in 
  (
  select rn 
  from 
  ( 
  select row_number() over(partition by ??(ÄãÒªÅÅÐòµÄ×Ö¶Î) rn order by rowid 
  from table1
  ) 
  where rn>=21 and rn <=30
  )

up


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

SQL serverÊý¾Ý¼¯³ö´íÇóÖú

Á½ÖÖ´íÎó£º
1.Èç¹ûÎÒÕâÑùÉêÃ÷£ºResultSet rs;´íÎóÌáʾÈçÏ£º

An error occurred at line: 51 in the jsp file: /index.jsp
The local variable rs may not have been initialized
48:    ......

SQL MAIL µÄÅäÖÃ

ÎÊÌâÃèÊö£º
ÎÒÓõÄÊÇsql 2000
ÆóÒµ¹ÜÀíÆ÷->Õ¹¿ª·þÎñÆ÷->¹ÜÀí->SQL Agent->ÊôÐÔ
ÔÚ´¦À´µÄSQL Server´úÀíÊôÐÔ¶Ô»°¿òÖÐ Óʼþ»á»°Ñ¡Ïî¿òÏÂÃæµÄ ÓʼþÅäÖÃÎļþ ²»ÄÜÓà ³ÊÏÖ»ÒÉ«
ÎÒͬѧµÄÈ´ÄÜÓᣠ......

myeclipseÖÐÈçºÎÓëSQL server2008 Á¬½Ó

ÔÚ΢Èí¹Ù·½ÏÂÔØÁËÒ»¸ösqljdbc_2.0Çý¶¯°ü£¬ÏëÓÃsqlserver2008Á¬½Ó¡£µ«×ÜÊÇÔÚÁ¬½ÓÊý¾Ý¿âʱÌáʾ³ö´í£¨ÓÐÒ»µãҪ˵Ã÷µÄÊÇÎҵĵçÄÔÀïÓÐÁ½¸öÊý¾Ý¿â°æ±¾Ò»¸öÊÇsqlserver2005(ĬÈϵÄʵÀý)»¹ÓÐÒ»¸ö¾ÍÊÇsqlserver2008(ÐèÒªÖ¸¶¨Ê ......

×Ü»áÅöµ½¹ÖµÄÎÊÌ⣬sqlÎÊÌâ

sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and  xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ