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

¼ÓÉϱíÃûºÍ±íÃèÊöºóÖ´ÐÐÒÔÏ´洢¹ý³Ì£¬¼´¿ÉΪ±íÌí¼ÓÃèÊö
EXEC

sys.sp_addextendedproperty @name=
N'MS_Description'
,

@value=
N'±íÃèÊö
'
,
@level0type=
N'SCHEMA'
,

@level0name=
N'dbo'
,

@level1type=
N'TABLE'
,

@level1name=
N'±íÃû'
......

Oracle SQLÓëANSI SQLÇø±ð


Oracle SQLÓëANSI SQLÇø±ð
ÏàÐÅ´ó¼Ò¶¼Ê¹ÓùýSQL SERVER¡£½ñÌì¸ø´ó¼Ò¼òµ¥½éÉÜÒ»ÏÂOracle SQLÓëANSI SQLÇø±ð¡£Æäʵ£¬SQL SERVERÓëÓëANSI SQLÒ²ÓÐÇø±ð¡£
1¡¢Ê×ÏÈ´ó¼ÒÒªÃ÷°×ʲôÊÇANSI
ANSI£ºÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨American National Standards Institute£©¡£µ±Ê±£¬ÃÀ¹úµÄÐí¶àÆóÒµºÍרҵ¼¼ÊõÍÅÌ壬ÒÑ¿ªÊ¼Á˱ê×¼»¯¹¤×÷£¬µ«Òò±Ë ......

±È½ÏÁ½ÌõSQLÓï¾äÔËÐÐʱ¼ä

create   proc   dbo.PROC_SQL_COMP   @sql1   varchar(8000),@sql2   varchar(8000),@t   int  
  as  
  /*  
  µ÷Óãºexec   dbo.PROC_SQL_COMP   @sql1='',@sql2='',@t=5 & ......

SQLÓÅ»¯¼°UNION ALLÌæ´úUNION

OracleÓкܶàÖµµÃѧϰµÄµØ·½£¬ÕâÀïÎÒÃÇÖ÷Òª½éÉÜOracle UNION ALL£¬°üÀ¨½éÉÜUNIONµÈ·½Ã档ͨ³£Çé¿öÏ£¬ÓÃUNIONÌæ»»WHERE×Ó¾äÖеÄOR½«»áÆðµ½½ÏºÃµÄЧ¹û¡£¶ÔË÷ÒýÁÐʹÓÃOR½«Ôì³ÉÈ«±íɨÃè¡£×¢Ò⣬ÒÔÉϹæÔòÖ»Õë¶Ô¶à¸öË÷ÒýÁÐÓÐЧ¡£¼ÙÈçÓÐcolumnûÓб»Ë÷Òý£¬²éѯЧÂÊ¿ÉÄÜ»áÒòΪÄúûÓÐÑ¡ÔñOR¶ø½µµÍ¡£ÔÚÏÂÃæµÄÀý×ÓÖУ¬LOC_ID ºÍREGION ......

SQL´æ´¢¹ý³Ìѧϰ


¡¡¡¡±¾ÎÄ´ÓSQL´æ´¢¹ý³ÌµÄ¸ÅÄÓŵ㣬Óï·¨£¬´´½¨¼¼ÇÉ£¬µ÷ÓÃµÈ¶à·½Ãæ½éÉÜÁËSQL´æ´¢¹ý³Ì¡£
¡¡¡¡Ò»¡¢SQL´æ´¢¹ý³ÌµÄ¸ÅÄÓŵ㼰Óï·¨
¡¡¡¡¡¡¶¨Ò壺½«³£ÓõĻòºÜ¸´ÔӵŤ×÷£¬Ô¤ÏÈÓÃSQLÓï¾äдºÃ²¢ÓÃÒ»¸öÖ¸¶¨µÄÃû³Æ´æ´¢ÆðÀ´, ÄÇôÒÔºóÒª½ÐÊý¾Ý¿âÌṩÓëÒѶ¨ÒåºÃµÄ´æ´¢¹ý³ÌµÄ¹¦ÄÜÏàͬµÄ·þÎñʱ,Ö»Ðèµ÷ÓÃexecute,¼´¿É×Ô¶¯Íê³ÉÃüÁî¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ