SQL·Ö¸î¶ººÅµÄº¯ÊýºÍÓ÷¨
ÔÚ³ÌÐòÖÐÎÒÃÇ¿ÉÄܾ³£»áÓöµ½ÕâÖÖÇé¿ö£¬±ÈÈçҪȡһ¸ölistboxÀïÃæµÄÑ¡ÔñÏµÃµ½µÄ½á¹û¿ÉÄÜÊÇstring ID="id1,id2,id3,id4",È»ºóÎÒÃÇÒª°ÑÕâЩID²åÈëµ½Êý¾Ý¿âÖУ¬Í¬Ê±Ã¿¸öid¶ÔÓ¦µÄÊÇÒª²åÈëÒ»Ìõ¼Ç¼¡£ÊµÏֵķ½·¨Óкܶ࣬µ«ÊÇÈç¹ûÎÒÃÇͨ¹ýÏÂÃæÕâ¸öº¯Êý£¨RecurrentSplit£©¾ÍÄܼòµ¥µÄ´ïµ½ÉÏÊöЧ¹û¡£RecurrentSplitµÄʹÓÃÒ²·Ç³£¼òµ¥¡£
ÀýÈ磺
select row_number()over(order by indexno desc) as seq ,* from recurrentsplit('1,2,3,4,5,',',',0,0)
ÕâÑùÎÒÃǾͻá·Ö³É5Ìõ¼Ç¼£¬ÒòΪÎÒµÄÒªÇóÊÇÒ»¸ölistboxÖÐitem[i]ÆäÖÐ×îСµÄ˵Ã÷ËûµÄÅÅÐòÔÚ×îǰͷ£¬Í¬Ê±ÅÅÐòÊǵ«SEQµÄ½µÐòÅÅÁС£ËùÒÔÔÚÕâ¸ö²éѯÖÐÎÒÓÃrow_number()over(order by indexno desc) as seqµÃ³öÁËËûµÄ˳ÐòºÅ
ÈçÏÂ
seq indexno SplitName
1 4 5
2 3 4
3 2 3
4 1 2
5 0 1
È»ºó¾ÍÊǶÔÕâ¸ö½á¹û½øÐвÙ×÷¿©
Èç
--ÉèÖÃÑ¡ÔñÉÌÆ·ÎªÍƼö²¢°´´«ÈëµÄ½µÐò½«ÉÌÆ·ÍƼöÅÅÐò
update zp_auction_mst
set ishot=1,hotseq = b.seq
from zp_auction_mst a,
(select row_number()over(order by indexno desc) as seq ,* from recurrentsplit(@AuctionID,',',0,0)) as b
where a.auctionid= b.splitName
¸ã¶¨£¬¾ÍÊÇÕâô¼òµ¥ÁË¡£¡£¡£¡£
CREATE FUNCTION [dbo].[RecurrentSplit]
(
@nvStr nvarchar(2000) --ÐèÒª·Ö¸î×Ö·û´®
,@vSeparte varchar(50) --·Ö¸î×Ö·û´®
,@iIsHaveSeparte int --ÊÇ·ñÏÔʾ×Ö·û´®
,@iIsBefore int --ÊÇ·ñÊǺóÃæµÄ·Ö¸î·û£¨·Ö¸î×Ö·û·Ö¸îµÄ˳Ðò£©
)
RETURNS @Split table
(
Ind
Ïà¹ØÎĵµ£º
´ò¿ª“¹ÜÀí¹¤¾ß¨D¨D×é¼þ·þÎñ”£¬ÒÔ´Ë´ò¿ª“×é¼þ·þÎñ¨D¨D¼ÆËã»ú”£¬ÔÚ“ÎҵĵçÄÔ”Éϵã»÷ÓÒ¼ü¡£
ÔÚMSDTCÑ¡ÏÖУ¬µã»÷“°²È«ÅäÖÔ°´Å¥¡£
ÔÚ°²È«ÅäÖô°¿ÚÖÐ×öÈçÏÂÉèÖãº
Ñ¡ÖÐ“ÍøÂçDTC·ÃÎÊ”
ÔÚ¿Í»§¶Ë¹ÜÀíÖÐÑ¡ÖГÔÊÐíÔ¶³Ì¿Í»§¶Ë”“ÔÊÐ ......
¡¾SQL¡¿ÐÐÁÐת»»
http://space.itpub.net/519536/viewspace-609167
Ò»¡¢ÁбäÐÐ
1.´´½¨²âÊÔ±ítest£¬²¢³õʼ»¯ÊµÑéÊý¾Ý
sec@ora10g> create table test (name_id varchar2(10), name varchar2(10));
sec@ora10g> insert into test values ('01','Andy1');
sec@ora10g> insert into test values ('01','Andy2'); ......
Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäË ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ëµ ......
¶ÔÕâ¸ö½øÐÐÓÅ»¯
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 n50
where to_char(n5010,'yyyymmdd')>='20 ......