Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

sql²éѯÎÊÌâ

²»ÖªµÀÎÒÃèÊöÇå³þÁËÂð£¬ÎÒÏÖÔÚÊÇÏëÒªÓÃÒ»¸ösqlÓï¾äʵÏÖÕâÑùµÄ¹¦ÄÜ£¬ÇëÎÊ¿ÉÒÔÂð£¬ÓÐûÓиüºÃµÄ°ì·¨À´ÊµÏÖ£¿
лл´ó¼ÒÁË
ʲô¹¦ÄÜ£¿

ÔÎ,

..

ΪʲôÎÒÃèÊöµÄÎÊÌâ·¢±í²»ÁË£¬×Ü˵ÓзǷ¨´Ê»ò´Ê×飬ÎÒ²éÁËÏÂû ......

Ò»¸ösqlÓï¾ä¡£

ÎÒÏë²é³ö
month
1
2
3
4
5
6
7
8
9
10
11
12
ÕâÑùµÄÊý¾Ý£¬ÈçºÎʵÏÖ°¡¡£¡£¡£

SQL code:

select top 12 month=identity(int,1,1) into #t from sysobjects
selec ......

SQL ¹ØÓÚ¶àÌõupdate

ÀýÈçÓÐ2¸ö±í Ò»¸öÊÇÔ±¹¤ÐÅÏ¢±í ±íÀïÓÐÃû×Ö ¹¤×ʵÈ×Ö¶Î Ò»¸öÊǹ«Ë¾²ÆÎñ±íÓРÿÔÂ×ÜÖ§³öµÈ×Ö¶Î

ÏÖÔÚÒª¸øÒ»¸öÔ±¹¤Õǹ¤×Ê 500RMB  ¾ÍҪд2Ìõ UPDATEÓï¾ä£¨¼ÙÉèÖ»ÓÐÁ½ÕÅ±í¡£Êµ¼Ê¿Ï¶¨Òª¸ü¶à£©

ÎÊ£ºÈçºÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ