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

Çë¸ßÊÖ°ïÎÒдһÌõsqlÓï¾ä

ǰ¼¸Ìì¹«Ë¾ÃæÊÔ£¬¼ûµ½Ò»Ìâ,Çë¸ßÊÖ°ïÎÒ½â´ð£¬Ð»Ð»£¡

ÄÚÈÝtable:
id    name    parentid
1      aaa    null
14    bbb    1
47    ccc    14
72    ddd    47

ÎÊÌ⣺

ÒÑÖª¼Ç¼ id=72,name='ddd',parentid=47
ÒªÇóÓÃÒ»ÌõsqlÓï¾ä»ñµÃËùÓбí¼Ç¼¡£


--ÊÇÕâÑùÂð£¿ÊÇÕâÑùµÄ»°£¬Ò²¾Í߯¼òµ¥ÁË£¡
select * from table where id=72 and name='ddd' and parentid=47;

ûÃ÷°×

select * from tb
?

Èç¹ûÊÇ2005,¿ÉÒÔ,ÄãÕÒСPÁºÐ´.

ÒýÓÃ
Èç¹ûÊÇ2005,¿ÉÒÔ,ÄãÕÒСPÁºÐ´.

Èç¹ûÊÇoracleÒ²¿ÉÒÔÕâÑùдÂð£¿

²»ÖªµÀ.

BOM½á¹¹

insert into @t_level select @id
select @id = pid from tb where id = @id and pid is not null
ÕâÓеãÔÎ ÔõôÓÐ2¸öselect ?

SQL code:
drop table test1;
drop table test2;
drop table test3;

create table test1(id int, name varchar(20), parentid int);
insert into test1(id, name, parentid) values(1,'luoyoumou1', 2)
insert into test1(id, name, parentid) values(72,'ddd', 47)
create table test2(id int, name varchar(20), parentid int);
insert into test2(id, name, parentid) values(2,'luoyoumou2', 3)
insert into test2(id, nam


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

sqlÓï¾ä»ñÈ¡¼Ç¼Êý

StrSQL="Select * from "&DataTable&" Where ID In("& ID &") and Shop_ID="&Shop_ID&Taxis


ÈçºÎ»ñÈ¡ËûµÄ¼Ç¼Êý?
@@ROWCOUNT

Select count(* ......

sql Óï¾ä

±íA
¿¨ºÅ         ʱ¼ä
1                 null
2                 null
3 & ......

¹ØÓÚSQL 2008

Ò»Ö±ÓÃ2000£¬Ïëѧ2008.
ÇëÎÊ
1. 2008±È2000ÓÐÄÄЩ¸ü·½±ãµÄÓ¦Óã¿
2. MSSQL 2008 Ö§³ÖÄÄЩϵͳ£¿ XP¿ÉÒÔ°²×°Âð£¿
3. ÔÚÄÄÓÐÏÂÔØ£¬×îºÃÊÇÃâϵÁкţ¬¼´D°æ¡£

лл£¡
ÎÒÒ²ÓÃ2000

1.Ì«¶àÁË ×Ô¼ºÈ¥ ......

SQLÌæ»»×Ö·û´®µÄÎÊÌâ

¸÷λ´óÏÀ£¬ÓиöÎÊÌâÇë½Ì£¬ÎÒÏÖÔÚÓÐÁ½ÕűíA,B×ֶζ¼ÓÐnum£¬Èç
A                    B
num                  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ