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

ÇóÒ»SQLÓï¾ä¡£Ð»Ð»

id    name    sfz

1    aa    410654198001204562
2    bb    410654198120461287
4    cc    410654198508025262
5    dd    410654198611236236
6    ee    410654198604163466


ÎÒÔÚºǫ́ÊäÈëÓû§Ãû(name)ºÍÃÜÂë(sfz)

ÃÜÂëÊÇÉí·ÝÖ¤µÄºó8λ¡£
±ÈÈç aa µÄÃÜÂë¾ÍÊÇ  01204562

È»ºóÎÒÊäÈëÍê±ÏÌá½»£¬ÔõôÔÚÊý¾Ý¿âÖнØÈ¡ sfz µÄºó°ËλÀ´ºÍÎÒÊäÈëµÄÃÜÂëÏà±È½ÏÄØ£¿

²»ÏëÏÈÈ¡³öÀ´ÔÙ½ØÈ¡×Ö·û´®£¬Ì«Âé·³£¬ÓÐûÓÐÅóÓÑÄܰïæָµãÏ£¬Ð»Ð»
subString()¾ÍÐÐÁË£¡

sqlÀïÃæ¿ÉÒÔÓã¡


ÒýÓÃ
SQL codeselect sfz1=substring(sfz,9,8)from tb


select * from table where name=aa and sfz=...

ºóÃæ²»»áд°¡¡£¡£¡£Çó½Ì£¡Ð»Ð»£¡

SQL code:
select substring(sfz,11,18) from tableName where id=1


ÒýÓÃ
SQL codeselect sfz1=substring(sfz,9,8)from tb

²»ºÃÒâ˼¡£´ò´íÁË

SQL codeselect sfz1=substring(sfz,11,8)from tb

ÒýÓÃ
SQL codeselect sfz1=substring(sfz,9,8)from tb


ÄãÕâ¸ö°Ñ³¤¶È¸øÐ´ËÀÁ˰ɡ£¡£

ÓеÄÉí·ÝÖ¤²»ÊÇ1


Ïà¹ØÎÊ´ð£º

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

ÇóÖúÒ»¾äSQLÓï¾ä

Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float

Êý¾ÝÈçÏ£º

Code      CreateTime          Price
031002 2008-10-17 15:00:15 ......

xmlµ¼ÈësqlÊý¾Ý¿â£¬¼±

¸÷λ´óÏÀ£¬ÎÒÓÐÒ»¸öxmlÎļþ
XML code:

<?xml version="1.0" encoding="GB2312"?>
<FileId fileid="86">
<ResultSet>
<row id="0">
......

ÇósqlÓï¾ä

×Ö¶Îaa,¹²ÓÐ178¸öÊý¾Ý,ÏÔʾʱÊÇÒ»ÁÐÖ±ÅÅÏÂÀ´µÄ,ÎÒÏëÈÃÕâ178¸öÊý¾Ý,ÿÁÐÖ»ÏÔʾ5¸ö,¶àÁÐÏÔʾÍê,ÈçºÎʵÏÖ?

¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ÒýÓÃ
¼ÓÒ»¸öIDENTITYTÁÐ,°´ID%5À´·Ö

ID-1/5À´·Ö


SQL co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ