Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ¶ÔxmlÀàÐ͵IJÙ×÷

 declare @XML XML
SET @XML='<root>
 <OLDVALUE>
  <H_Action id="1130">030</H_Action>
  <D_Action>030</D_Action>
  <OrderCompany>00220</OrderCompany>
  <OrderNumber>10004035</OrderNumber> ......

ÔÚsql serverÖÐÊäÈë'NULL'×Ö·û´®µÄÓÐȤ·¢ÏÖ£¡

Èçͼ1¡¢2£¬id=1µÄÊý¾ÝÊÇNULL£¬ÆäËûµÄΪ·ÇNULLµÄÊý¾Ý¡£
Ò»°ãÇé¿öÏ£¬»áÓÃÁ½ÖÖ·½·¨£¡
·½·¨1.t-sql£ºinsert into E values(1,'NULL')£¬²åÈëºó£¬ÔÚ´ò¿ª±íµÄÇé¿öÏ¿´µ½µÄ
ÊÇ'NULL'£¨ÎÒÏëÊÇΪÁËÇø·ÖNULL£¬²Å¼ÓµÄÒýºÅ£©£¬µ«ÊDzéѯµÄʱºò²»Ó°Ï죬ÏÔʾµÄÊÇNULL£¬
Èçͼ1¡¢2£¬idΪ6µÄÊý¾Ý¡£
Èç¹ûÒª²åÈë´øµ¥ÒýºÅµÄ'NULL'£¬insert i ......

»ñÈ¡SQL ServerËùÓÐÊý¾Ý¿âÃû£¬±íÃû£¬×Ö¶ÎÃû


/*
 * Source URL: http://jonsion.javaeye.com/blog/511584
 */
1. »ñÈ¡ËùÓÐÊý¾Ý¿âÃû
1> SELECT name from master..sysdatabases;
2> go
2. »ñÈ¡ËùÓбíÃû
1> USE master
2> go
1> SELECT name from sysobjects WHERE type='U';
2> go
3. »ñÈ¡ËùÓÐ×Ö¶ÎÃû
1> SELECT name ......

»ùÓÚSQLµÄ·ÖÒ³

select top PageSize * from ±í
where Ìõ¼þ and id not in
(select top PageSize*(CurrentPageIndex-1)  id from ±í where Ìõ¼þ order by ÅÅÐòÌõ¼þ)
order by ÅÅÐòÌõ¼þ
¡¶PageSize ÊÇGridViewÖÐÿҳÏÔʾµÄÐÅÏ¢ÌõÊý£¬PageSize*(CurrentPageIndex-1) ÔÚSQLÖв»Ê¶±ð£¬Ð趨Òå±äÁ¿À´Ìæ»»¡· ......

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ºÅ