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

ÔÚSQL Server ɾ³ýÖØ¸´Êý¾Ý

ɾ³ýÊý¾Ý¿â±íÖÐijһ×ֶεÄÖØ¸´¼Í¼£¬Ö»Ïë±£ÁôÒ»Ìõ¼Ç¼¿ÉÓÃÒÔÏ·½·¨£º
Ö´ÐÐÒÔÏÂÓï¾ä£º
declare @max integer,@id varchar(18) --´Ë´¦±äÁ¿ÀàÐ͸ù¾Ý×Ö¶ÎÀàÐÍÉèÖÃ
declare cur_rows cursor local for select ×Ö¶Î,count(*) from ±íÃûgroup by ×Ö¶Î having count(*) > 1
open cur_rows
fetch cur_rows into @id,@max
while @@fetch_status=0
begin
 select @max = @max -1
 set rowcount @max
 delete from ±íÃûwhere ×Ö¶Î = @id
 fetch cur_rows into @id,@max
end
close cur_rows
set rowcount 0


Ïà¹ØÎĵµ£º

sql server·Ö²¼Ê½ÊÂÎñ½â¾ö·½°¸

ÊÊÓû·¾³
²Ù×÷ϵͳ£ºwindows 2003
Êý¾Ý¿â£ºsql server 2000/sql server 2005
ʹÓÃÁ´½Ó·þÎñÆ÷½øÐÐÔ¶³ÌÊý¾Ý¿â·ÃÎʵÄÇé¿ö
Ò»¡¢  ÎÊÌâÏÖÏó
ÔÚÖ´Ðзֲ¼Ê½ÊÂÎñʱ£¬ÔÚsql server 2005ÏÂÊÕµ½ÈçÏ´íÎó£º
ÏûÏ¢ 7391£¬¼¶±ð 16£¬×´Ì¬ 2£¬¹ý³Ì xxxxx£¬µÚ 16 ÐÐ
ÎÞ·¨Ö´ÐиòÙ×÷£¬ÒòΪÁ´½Ó·þÎñÆ÷ "xxxxx" µÄ OLE DB ·ÃÎÊ½Ó¿Ú " ......

SQL »ñȡϵͳÎļþ

--»ñµÃµ±Ç°ËùÓÐÇý¶¯Æ÷
exec master.dbo.xp_availablemedia
--»ñµÃ×ÓĿ¼Áбí
exec master.dbo.xp_subdirs 'c:\'
--»ñµÃËùÓÐ×ÓĿ¼µÄĿ¼Ê÷½á¹¹
exec master.dbo.xp_dirtree 'c:\'
--¶©ÔÄÎļþɾ³ý
declare @tempTable table (Cont varchar(50))
declare @strTemp varchar(50)
declare @dirPath varchar(50)
declar ......

SQL Server°²×°Ê±COM+Ŀ¼ҪÇóÎÊÌâµÄ½â¾ö·½·¨

ºÜÔç¾Í²»ÓÃSQLServer 2005ÁË£¬½ñÌìͻȻ½Óµ½¸öÏîÄ¿£¬Ëµ·ÇÓÃSQLServer²»¿É£¬Ã»°ì·¨£¬Ö»ºÃ°Ñ¾ÃÎ¥µÄÀÏÅóÓÑ×°ÉÏÈ¥ÁË£¬Óöµ½ÁËCOM+µÄĿ¼ҪÇó²»ÐеÄÎÊÌ⣬ÒÔǰÕâ¸öÎÊÌâÎÒҲûÓÐ×¢Ò⣬½ñÌìÏë½â¾öϸø´ó»ï¿´¿´¡£
¡¡¡¡½â¾öµÄ·½·¨ÆäʵºÜ¼òµ¥£¬ÈçÏ£º
¡¡¡¡1¡¢¿ª»§MSDTC·þÎñ£º“¿ªÊ¼-ÔËÐД£¬ÊäÈë"cmd"ºó»Ø³µ ......

¶Ôpl/sql Óï¾äµÄÓÅ»¯£¨Ï¼¯£©

Éϼ¯ÖÐ
//////////////////////////////////////////////////
select n5001 Ãŵê,n5002 ²¿ÃÅ,n5004 С·ÖÀà,n5019 ÉÌÆ·±àÂë,c01d21 ÉÌÆ·Ãû³Æ,
nvl(xse,0)-nvl(dzxs,0) ÏúÊÛ,
mle ëÀû,
nvl(xl,0)-nvl(dzsl,0) ÏúÁ¿
 from
(select n5001,n5002,n5004,n5019,sum(n5011) xse,sum(n5016) mle,sum(n5023) xl
from ......

ORACLE SQL ÓÅ»¯

http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
Çø×¨ÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ