³£ÓÃ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×Ö·û´®´¦Àíº¯Êý´óÈ«
selectÓï¾äÖÐÖ»ÄÜʹÓÃsqlº¯Êý¶Ô×ֶνøÐвÙ×÷£¨Á´½Ósql server£©£¬
select ×Ö¶Î1 from ±í1 where ×Ö¶Î1.IndexOf("ÔÆ")=1;
ÕâÌõÓï¾ä²»¶ÔµÄÔÒòÊÇindexof£¨£©º¯Êý²»ÊÇsqlº¯Êý£¬¸Ä³Ésql¶ÔÓ¦µÄº¯Êý¾Í¿ÉÒÔÁË¡£
left£¨£©ÊÇsqlº¯Êý¡£
select ×Ö¶Î1 from ±í1 where charindex£¨'Ô ......
SQL SERVER 2005 ÖеÄÈÕÆÚʱ¼äÀàÐÍ
Ò»£® Êý¾ÝÀàÐÍ
MS SQL Server 2005 ÓÐ datetime ºÍ smalldatetime Á½ÖÖ¸ñʽµÄÈÕÆÚʱ¼äÊý¾ÝÀàÐÍ¡£×¢Ò⣺ûÓе¥¶ÀµÄÈÕÆÚ»òʱ¼äÀàÐÍ¡£
datetime
Êý¾Ý¿âÄÚ²¿ÓÃÁ½¸ö 4 ×Ö½ÚµÄÕûÊý´æ´¢ datetime Êý¾ÝÀàÐ͵ÄÖµ¡£µÚÒ»¸ö 4 ×Ö½Ú´æ´¢»ù´¡ÈÕÆÚ£¨¼´ 1900-1-1, base ......
н¨±í£º
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 [±í ......
using System.Data.SqlClient;
using System.Data.OleDb;
private void tsmiImportTeacherInfo_Click(object sender, EventArgs e)
{
DataSet ds;
  ......
sysaltfiles ÔÚmasterÊý¾Ý¿âÖУ¬°üº¬ÓëÊý¾Ý¿âÎļþÏà¶ÔÓ¦µÄÐÅÏ¢£¬°üº¬ËùÓÐÊý¾Ý¿âµÄÊý¾ÝÎļþÒÔ¼°ÈÕÖ¾Îļþ
ÁÐÃûÊý¾ÝÀàÐÍÃèÊö
fileid
smallint
ÿ¸öÊý¾Ý¿âµÄΨһÎļþ±êʶºÅ¡£1´ú±íÊý¾ÝÎļþ£¬2´ú±íÈÕÖ¾Îļþ
groupid
smallint
Îļþ×é±êʶºÅ¡£
size
int
Îļþ´óС£¨ÒÔ 8 KB ҳΪµ¥Î»£©¡£Ò³µÄÊýÄ¿
maxsize
......