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

SQLÊ¡ÊÐÇøÈý¼¶±í ˵ÉùллÔÙÄÃ

-- ±íµÄ½á¹¹ area
DROP TABLE  area;
CREATE TABLE  area (
  id int NOT NULL ,
  areaID int NOT NULL,
  area varchar(200) NOT NULL,
  fatherID int NOT NULL,
  PRIMARY KEY  (id)
)
DROP TABLE city;
CREATE TABLE  city select
  id int NOT NULL ,
  cityID int NOT NULL,
  city varcharselect 200) NOT NULL,
  fatherID int NOT NULL,
  PRIMARY KEY  select id)
)
--
-- µ¼³ö±íÖеÄÊý¾Ý city
--
-- --------------------------------------------------------
--
-- ±íµÄ½á¹¹ province
--
DROP TABLE  province;
CREATE TABLE province select
  id int NOT NULL ,
  provinceID int NOT NULL,
  province varcharselect 200) NOT NULL,
  PRIMARY KEY  select id))
insert  province(id,provinceID,province)
 select 1,110000,'±±¾©ÊÐ' union
 select 2,120000,'Ìì½òÊÐ' union
 select 3,130000,'ºÓ±±Ê¡' union
 select 4,140000,'ɽÎ÷Ê¡' union
 select 5,150000,'ÄÚÃɹÅ×ÔÖÎÇø'union
select 6,210000,'ÁÉÄþÊ¡' union
select 7,220000,'¼ªÁÖÊ¡' union
select 8,230000,'ºÚÁú½­Ê¡' union
select 9,310000,'ÉϺ£ÊÐ' union
select 10,320000,'½­ËÕÊ¡' union
select 11,330000,'Õã½­Ê¡' union
select 12,340000,'°²»ÕÊ¡' union
select 13,350000,'¸£½¨Ê¡' union
select 14,360000,'½­Î÷Ê¡' union
select 15,370000,'ɽ¶«Ê¡' union
select 16,410000,'ºÓÄÏÊ¡' union
select 17,420000,'ºþ±±Ê¡' union
select 18,430000,'ºþÄÏÊ¡' union
select 19,440000,'¹ã¶«Ê¡' union
select 20,450000,'¹ãÎ÷׳×å×ÔÖÎÇø' union
select 21,460000,'º£ÄÏÊ¡' union
select 22,500000,'ÖØÇìÊÐ' union
select 23,510000,'ËÄ´¨Ê¡' union
select 24,520000,'¹óÖÝÊ¡' union
select 25,530000,'ÔÆÄÏÊ¡' union
select 26,540000,'Î÷²Ø×ÔÖÎÇø' union
select 27,610000,'ÉÂÎ÷Ê¡' union
select 28,620000,'¸ÊËàÊ¡' union
select 29,630000,'Çຣʡ' union
select 30,640000,'ÄþÏÄ»Ø×å×ÔÖÎÇø' union
select 31,650000,'н®Î¬Îá¶û×ÔÖÎÇø' union
select 32,710000,'̨ÍåÊ¡' union
select 33,810000,'Ïã¸ÛÌØ±ðÐÐÕþÇø' union
select 34,820000,'°ÄÃÅÌØ±ð


Ïà¹ØÎĵµ£º

SQL Éè¼ÆÄ£Ê½

1¡¢SQLÊÇÒ»ÖÖ˵Ã÷ÐÔÓïÑÔ£¬²»Êǹý³Ì»¯ÓïÑÔ¡£ÀàËÆ“¼ìË÷->¼ì²é->²åÈë->¸üДµÄ¹ý³Ì»¯²½ÖèµÄ˳ÐòÊÇûÓÐÒâÒåµÄ¡£Ó¦¸ÃÒÔÐм¯µÄ·½Ê½Ë¼¿¼£¬ÒÔÃèÊöÒ»¸öÂß¼­µÄÓïÑÔ·½Ê½Ë¼¿¼¡£
2¡¢ÔÚÉè¼ÆÊý¾Ý¿â±í×Ö¶Îʱ£¬Ò»¸öÐÐÃèÊöÓ¦¸Ã°üº¬Ò»¸öÊÂʵ£¬¶øÇÒÊÇÈ«²¿ÊÂʵ¡£ÀýÈ翼ÇÚ¿¨µÄÉè¼Æ£¬
²»ÒªÉè¼ÆÎª£º[ userId, puchTime, even ......

SQLÃüÁî²éѯOracle´æ´¢¹ý³ÌÐÅÏ¢£¨´úÂëÄÚÈݵȣ©

SELECT * from ALL_SOURCE 
where TYPE='PROCEDURE'  AND TEXT LIKE
'%0997500%';
--²éѯALL_SOURCEÖУ¬£¨½Å±¾´úÂ룩ÄÚÈÝÓë0997500Ä£ºýÆ¥ÅäµÄÀàÐÍΪPROCEDURE£¨´æ´¢¹ý³Ì£©µÄÐÅÏ¢¡£
¸ù¾ÝGROUP
BY TYPE
¸ÃALL_SOURCEÖÐÖ»ÓÐÒÔÏÂ5ÖÖÀàÐÍ
1 FUNCTION
2 JAVA
SOURCE
3 PACKAGE
4 P ......

SQLµÄ¼¸¸ö±àÂë¹æ·¶


1.±ÜÃâÔÚwhere×Ó¾äÖжÔ×Ö¶ÎÊ©¼Óº¯Êý£¬ÕâÑù½«µ¼ÖÂË÷ÒýʧЧ£¬±ÈÈ磺
select * from user where
to_char(create_time,'yyyymmdd')='20090101';
Ô­Òò£ºÔÚ½¨Á¢indexµÄʱºòÊǸù¾Ý×Ö¶ÎÀ´½¨Á¢µÄ£¬Ò²¾ÍÊÇ˵oracleÔÚinidexµÄʱºòÊÇË÷ÒýµÄ×ֶεÄÖµ£¬Èç¹ûÌṩ¸øoracleµÄÊÇÒ»¸öÐèÒª¾­¹ýº¯Êý´¦ÀíµÄ±È½Ï£¬oracle¾Íû°ì·¨Í¨¹ýË÷ÒýÖÐµÄ ......

ADO.NETÖÐSQL ServerÊý¾Ý¿âÁ¬½Ó³Ø


Á¬½Óµ½Êý¾Ý¿â·þÎñÆ÷ͨ³£Óɼ¸¸öÐèÒªºÜ³¤Ê±¼äµÄ²½Öè×é³É¡£ ±ØÐ뽨Á¢ÎïÀíͨµÀ£¨ÀýÈçÌ×½Ó×Ö»òÃüÃû¹ÜµÀ£©£¬±ØÐëÓë·þÎñÆ÷½øÐгõ´ÎÎÕÊÖ£¬±ØÐë·ÖÎöÁ¬½Ó×Ö·û´®ÐÅÏ¢£¬±ØÐëÓÉ·þÎñÆ÷¶ÔÁ¬½Ó½øÐÐÉí·ÝÑéÖ¤£¬±ØÐëÔËÐмì²éÒÔ±ãÔÚµ±Ç°ÊÂÎñÖеǼǣ¬µÈµÈ¡£
ʵ¼ÊÉÏ£¬´ó¶àÊýÓ¦ÓóÌÐò½öʹÓÃÒ»¸ö»ò¼¸¸ö²»Í¬µÄÁ¬½ÓÅäÖᣠÕâÒâζ×ÅÔÚÖ´ÐÐÓ¦ÓóÌÐòÆ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ