Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ServerÊý¾Ý¿âÖÐÉè¼Æ±íºÍ×Ö¶Î

ת×Ô£ºhttp://news.newhua.com/news1/program_database/2008/530/0853092638H5D5AAC4I06BI1G22DCAH8H8B7HIGB0G3F109J6E7F9K2_2.html?lt=common
1. ԭʼµ¥¾ÝÓëʵÌåÖ®¼äµÄ¹ØÏµ
¿ÉÒÔÊÇÒ»¶ÔÒ»¡¢Ò»¶Ô¶à¡¢¶à¶Ô¶àµÄ¹ØÏµ¡£ÔÚÒ»°ãÇé¿öÏ£¬ËüÃÇÊÇÒ»¶ÔÒ»µÄ¹ØÏµ£º¼´Ò»ÕÅԭʼµ¥¾Ý¶ÔÓ¦ÇÒÖ»¶ÔÓ¦Ò»¸öʵÌå¡£ÔÚÌØÊâÇé¿öÏ£¬ËüÃÇ¿ÉÄÜÊÇÒ»¶Ô¶ ......

SQL ServerÊÂÎñÈÕÖ¾ÒâÍâÔö´óµÄ´¦Àí·½·¨

ת×Ô£ºhttp://news.newhua.com/news1/program_database/2008/530/0853093226E2KJ93C02415FEB1CD9A5HCKA821556279EEKJ7728GI5.html
ÊÂÎñÈÕÖ¾ÎļþTransaction Log FileÊÇÓÃÀ´¼Ç¼Êý¾Ý¿â¸üÐÂÇé¿öµÄÎļþ£¬À©Õ¹ÃûΪldf¡£
ÔÚ SQL Server 7.0 ºÍ SQL Server 2000 ÖУ¬Èç¹ûÉèÖÃÁË×Ô¶¯Ôö³¤¹¦ÄÜ£¬ÊÂÎñÈÕÖ¾Îļþ½«»á×Ô¶¯À©Õ¹¡£
Ò»° ......

SQL Éè¼ÆÄ£Ê½

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

SQL code

C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFAULT Ô¼Êø
F = FOREIGN KEY Ô¼Êø
FN = ±êÁ¿º¯Êý
IF = ÄÚǶ±íº¯Êý
K = PRIMARY KEY »ò UNIQUE Ô¼Êø
L = ÈÕÖ¾
P = ´æ´¢¹ý³Ì
R = ¹æÔò
RF = ¸´ÖÆÉ¸Ñ¡´æ´¢¹ý³Ì
S = ϵͳ±í
TF = ±íº¯Êý
TR = ´¥·¢Æ÷
U = Óû§±í
V = ÊÓͼ
X = À©Õ¹´æ´¢¹ý³Ì
......

SQLÖ® case when then

 ÊÓͼ²éѯÖÐÔõÑù½«Ô­¶¨ÓÚÈçÐÔ±ðsex ÕâÑùµÄ×ֶΣ¬×Ö¶ÎֵΪ0£¬1ÕâÑùµÄintÀàÐÍÖµ£¬²éѯʱֱ½Ó·µ»Øvarchar
Ð͵Ä×Ö·û‘ÄÐ’£¬‘Å®’ÒÔ±ãÓÚÎÒÃǶÁÈ¡ÄØ£¿
      
ÓÐÈË»áÏëµ½if …else…ÕâÑùµÄÓï¾ä£¬¿ÉÊÇÔõô¼Ó£¬¶¼²»ÖªµÀ¼ÓÄÄÀÒòΪ×ÜÊÇ»á³ö´í¡£Æä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ