Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sql

excelµ¼Èësql server2005µÄÎÊÌâ

[Excel Ô´ [1]] ´íÎó: Êä³ö¡°Excel Ô´Êä³ö¡±(9) É쵀 Êä³öÁС°Description 3¡±(546) ³ö´í¡£·µ»ØµÄÁÐ״̬ÊÇ:¡°Îı¾±»½Ø¶Ï£¬»òÕßÒ»¸ö»ò¶à¸ö×Ö·ûÔÚÄ¿±ê´úÂëÒ³ÖÐûÓÐÆ¥ÅäÏî¡£¡±¡£

¸ÃÁÐÔÚexcelÖÐ×Ϊ308¸ö×Ö·û£¬µ«ÊÇexcelÔ´ÖеÄÍⲿÁкÍÊä³öÁÐ×î¶àÖ»ÄÜÉèΪNvarchar(255),Èç¹ûÉ趨³¤¶È³¬¹ý255£¬Ôò³öÏÖ¾¯¸æ£¬Ô´ÁÐÊôÐÔ²»Æ ......

SQLºó»¨Ô°

¾ÍÏë¿´¿´¶àÉÙÈ˽øÀ´£¡
¿´¿´ºó»¨Ô°Õâ¸ö´ÊºÅÕÙÁ¦Óжà´ó£¬±¾ÌùÊÇÎÞÁÄÌù~~~~~~~~
.



·¹ýµÄ

·¹ý¡£½Ó·Ö¡£

.  û·Ö Äã½Ó¸öɶ

ºó»¨Ô°Íϵع¤Æ®¹ý

...

ÀϵÄÀ´ÁË

ÎÒÒ²ÏëÈ¥Íϵأ¡

ÎÒÒ²ÏëÈ¥Íϵأ¡

進來²È個腳Ó¡¡£¡£

1

0

½øÀ´±¨µÀ


±»Æ­ÁË

Õâ¸ö´ÊºÜÊ ......

SQLÖеÄÒÉ»ó

Êý¾Ý Ϊ £º
10001 ·Èݱ£½à 10000
10002 Â·Ãæ 10000
10003 ·»ù 10000
10004 ÇÅËíº­ 10000
10005 ÑØÏßÉèÊ© 10000
10006 »úµçÉèÊ© 10000
10007 ÂÌ»¯ 10000
10008 »úе±£½à 10001
10009 È˹¤±£½à 10001
10010 żȻʼþ 10001
10011 Á¤ÇàíÅÂ·Ãæ 10002
10012 Ë®ÄàíÅÂ·Ãæ 10002 ......

SQL like ÎÊÌâ

select ID,MainFunctionID,MainFunction,MainID,MainIDDescription,ModeID,ActionPageName,ActionBtnName,Description,IsActive,ModifyID,ModifyDate 
    from T_LogWriteSet  where MainID = ''' AND Description Like '%'%'

ÇëÎÊ AND Description Like ' ......

SQL ²ð·Ö×Ö·û´®

ÓÐtb±í

id      tags

1        1,2,3
2        1,2
3        1,5,10
4        2,6
5        4,9,15
6        5,8


Èç¹ûÒª¸ù¾Ýtags È¡ ......

ÇóÖúsqlд·¨

¸÷λ´óÏÀ£¬ÇóÖúsql
Ô­±í
A    B        time
A1  down      10:01
A1  up        10:02
A1  down      10:25
A1  up        10:35
A2  down    ......
×ܼǼÊý:3315; ×ÜÒ³Êý:553; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [476] [477] [478] [479] 480 [481] [482] [483] [484] [485]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ