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

¸ßÊÖ,ÇóÒ»oracle sql²éѯ¹¦ÄÜ - Oracle / ¿ª·¢

-----²âÊÔ±í(oracle 10G):
create table portal_his.testuser(
XH numeric NOT NULL ,-----¸Ã×Ö¶ÎÖµÊÇΨһµÄ;
deptid numeric NOT NULL ,
zwid numeric NULL ,
names varchar(20) NULL,
constraint testuser_pk PRIMARY KEY (XH) 
);


------²âÊÔÊý¾Ý:
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(1,1,2,'a1');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(2,1,2,'a1');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(3,1,3,'a3');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(4,1,2,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(5,2,4,'a4');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(6,2,6,'a4');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(7,2,10,'a5');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(8,3,10,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(9,2,10,'');
insert into portal_his.testuser(XH,deptid,zwid,names) 
values(10,3,10,'a7');


Çósql²éѯ¹¦ÄÜ:
-----Èç¹ûnames×Ö¶ÎֵΪ''»ònull,Ôò°Ñ¸Ã¼Ç¼ÖÐdeptidºÍzwidÖµÏàµÈµÄnames×Ö¶ÎÖµÄÚÈÝȡһ¸ö³öÀ´(Èç¹ûÕÒµ½¾Íȡһ¸ö³öÀ´,ûÓÐÕÒµ½¾Í²»¹ÜËü).
xh deptid zwid names
1 1 2 a1
2 1 2 a1
3 1 3 a3
4 1 2 -----ÕâÀïµÄ²éѯ


Ïà¹ØÎÊ´ð£º

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ