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

³£ÓÃSQLÓï¾ä[ÒÔµ³Ô±¹ÜÀíϵͳΪÀý]

µ³Ô±¹ÜÀíϵͳµÄÊý¾Ý¿âÉè¼Æ
ÐèÒªÒÔÏÂ×ֶΣº
l  ѧÉú£º
//ѧÉú»ù±¾ÐÅÏ¢
u  ѧÉúѧºÅ[id]£¨char£©Ö÷¼ü
u  ѧÉúÉí·ÝÖ¤ºÅ[id_num]£¨char£©
u  ѧÉúÐÕÃû[name]£¨char£©
u  ѧÉú³öÉúÈÕÆÚ[born_date]£¨date£©
u  ѧÉú¼®¹á[native]£¨int£©Íâ¼ü
u  ѧÉú¼Òͥסַ[address]£¨char£©
u  ѧÉú¼ÒÍ¥Óʱà[home_zip]£¨char£©
u  ѧÉúÐÔ±ð[sex]£¨bit£©
u  ѧÉúÕþÖÎÃæÃ²[polity]£¨int£©Íâ¼ü
u  ѧÉúËùÊôѧԺ[school]£¨int£©Íâ¼ü
u  ѧÉúËùÊô°à¼¶[class]£¨int£©Íâ¼ü
u  ѧÉúËùÊôµ³Ö§²¿[party]£¨int£©Íâ¼ü
u  ѧÉúÊÖ»úºÅÂë[mobilephone]£¨char£©
u  ѧÉúÊÖ»úºÅÂë[telephone]£¨char£©
u  ѧÉúÃñ×å[nation]£¨int£©
//ÅàÑøÈË
u  ÅàÑøÈË1[foster_one]£¨char£©
u  ÅàÑøÈË2[foster_two]£¨char£©
//¸÷½×¶Îʱ¼ä
u  µÝ½»Èëµ³ÉêÇëÊéʱ¼ä[hand_date]£¨date£©
u  È·¶¨Îª»ý¼«·Ö×Óʱ¼ä[sure_date] £¨date£©
u  ³ÉΪԤ±¸µ³Ô±Ê±¼ä[pre_date] £¨date£©
u  תΪÕýʽµ³Ô±Ê±¼ä[official_date] £¨date£©
//Èëµ³²ÄÁÏÏà¹ØÐÅÏ¢
u  Èëµ³ÉêÇëÊé[application]£¨bit£©
u  Èëµ³»ý¼«·Ö×Ó¿¼²ìµÇ¼Ç±í[review]£¨bit£©
u  ×Ô´«[memoir]£¨bit£©
u  ˼Ïë»ã±¨·ÝÊý[reports]£¨int£©
u  ÕþÉó²ÄÁÏ[political]£¨bit£©
u  Õ÷Çóµ³ÍâȺÖÚÊéÃæÒâ¼û[idea]£¨bit£©
u  µ³Ð£Åàѵ²ÄÁÏ[train]£¨bit£©
u  ÍÆÓÅÈëµ³²ÄÁÏ[commend]£¨bit£©
//ѧÉú¸¸Ä¸Ïà¹ØÐÅÏ¢
u  ¸¸Ç×ÐÕÃû[father_name]£¨char£©
u  ¸¸Ç׵绰[father_tel]£¨char£©
u  ¸¸Ç×µ³Ö§²¿Ãû³Æ[father_party]£¨char£©
u  ¸¸Ç×µ³Ö§²¿Óʱà[father_zip]£¨char£©
u  ĸÇ×ÐÕÃû[mother_name]£¨char£©
u  ĸÇ׵绰[mother_tel]£¨char£©
u  ĸÇ×µ³Ö§²¿Ãû³Æ[mother_party]£¨char£©
u  ĸÇ×µ³Ö§²¿Óʱà[mother_zip]£¨char£©
 
l  µ³Ö§²¿£º
u  µ³Ö§²¿±àºÅ[party_id]£¨int£©
u  µ³Ö§²¿Ãû³Æ[party_name]£¨char£©
u  µ³Ö§²¿ËùÊôѧԺ[party_school]£¨int£©Íâ¼ü
u  µ³Ö§²¿¹«¸æ[inform]£¨char£©
u  µ³Ö§²¿Êé¼Ç[secretary ]£¨char£©Íâ¼ü
u  µ³Ö§²¿Ðû´«Î¯Ô±[propaganda]£¨char£©Íâ¼ü
u  µ³Ö§²¿×é֯ίԱ[organization]£¨char£©Íâ¼ü
 
l  ÕþÖÎÃæÃ²£º
u  ÕþÖÎÃæÃ²±àºÅ[polity


Ïà¹ØÎĵµ£º

SQL Server º¯Êý´óÈ«

SQL Server×Ö·û´®´¦Àíº¯Êý´óÈ«
 selectÓï¾äÖÐÖ»ÄÜʹÓÃsqlº¯Êý¶Ô×ֶνøÐвÙ×÷£¨Á´½Ósql server£©£¬
select ×Ö¶Î1 from ±í1 where ×Ö¶Î1.IndexOf("ÔÆ")=1;
ÕâÌõÓï¾ä²»¶ÔµÄÔ­ÒòÊÇindexof£¨£©º¯Êý²»ÊÇsqlº¯Êý£¬¸Ä³Ésql¶ÔÓ¦µÄº¯Êý¾Í¿ÉÒÔÁË¡£
left£¨£©ÊÇsqlº¯Êý¡£
select ×Ö¶Î1 from ±í1 where charindex£¨'Ô ......

SQl Óï¾ä(³£¼û) н¨,ɾ³ý,Ð޸ıí½á¹¹

н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......

PL/SQL Developer ÖÐÎÄÂÒÂë½â¾ö

1¡£select * from v$nls_parameters 
²éѯnlsµÄ²ÎÊý£¬»ñµÃÊý¾Ý¿â·þÎñÆ÷¶ËµÄ×Ö·û±àÂë 
NLS_LANGUAGE 
NLS_CHARACTERSET 
2¡£Ð޸ı¾µØ»·¾³±äÁ¿£¬ÉèÖà
NLS_LANG = SIMPLIFIED CHINESE.ZHS16GBK //Õâ¸öÊÇÎÒÃǵÄÊý¾Ý¿â×Ö·û±àÂë 
NLS_LANG¸ñʽ£º 
NLS_LANG = language_territory.char ......

accessÓëSqlServer ֮ʱ¼äÓëÈÕÆÚ¼°ÆäËüSQLÓï¾ä±È½Ï

1¡¢Datediff£º
1.1Ëã³öÈÕÆÚ²î£º
1.access:       datediff('d',fixdate,getdate())
2.sqlserver:    datediff(day,fixdate,getdate())
ACCESSʵÀý£º    select * from table where data=datediff('d',fixdate,getdate())
sqlserverʵÀý£º select * from ......

sqlÀïµÄexistsÓëin¡¢not existsÓënot inµÄÇø±ð

ϵͳҪÇó½øÐÐSQLÓÅ»¯£¬¶ÔЧÂʱȽϵ͵ÄSQL½øÐÐÓÅ»¯£¬Ê¹ÆäÔËÐÐЧÂʸü¸ß£¬ÆäÖÐÒªÇó¶ÔSQLÖеIJ¿·Öin/not inÐÞ¸ÄΪexists/not exists
Ð޸ķ½·¨ÈçÏ£º
inµÄSQLÓï¾ä
SELECT id, category_id, htmlfile, title, convert(varchar(20),begintime,112) as pubtime
from tab_oa_pub WHERE is_check=1 and
category_id in (sel ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ