Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÓïÑÔÎÊÌâ

xuehao '#9'VarChar(100) NOT NULL  Default 0,  --12  20'#23383#33410#9#24080#25143#22995#21517
ÄܰïÎÒ½âÊÍһϠÿ¸ö´Ê´ú±íµÄÒâ˼Â𣿠лл£¡
ºóÃæÄÇÒ»´®ÊÇʲô£¿

'#9' Õâ¸öÊÇ´íµÄ¡£
xuehaoÊǶ¨ÒåÒ»¸ö×Ö¶ÎÃû£¬VarChar(100)×Ö¶ÎÀàÐÍ£¬NOT NULL·Ç¿ÕÔ¼Êø£¬Default 0 ¶¨ÒåÄ ......

ÎʸöSQLÔõôд

ÏÖÔÚÓÐ2¸ö±í
Group±í
SQL code:

GroupID GroupName
1 A×é
2 B×é


UserGroup±í
SQL code:

ID UserID GroupID
1 3 1
2 4 1


ÏÖÔÚÎÒÏëÈ¡³öÕâÑùµÄÊý¾Ý
GroupID  GroupName    Group±íÖеÄÓ ......

¼òµ¥µÄSQLÎÊÌ⣡

SQL code:

declare @t1 table(ÊýÖµ decimal(10,2))
insert into @t1 values(200)
insert into @t1 values(150)
insert into @t1 values(199)
insert into @t1 values(200)
select sum(ÊýÖµ)as a ,a*2 as b from @t1
ÏëÒªµÄ½á¹û
===========================================
a b
749.00 14 ......

Çë½ÌSQLÓï¾ä

A±í£¨Ö÷±í£©
A1£¨Ö÷¼ü£©    A2
1            ÕÅÈý


B±í
B1£¨Íâ¼ü£©    B2
1              ZHONG
1              GUO


C±í
C1£¨Íâ¼ü£©    C ......

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

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

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

SQLºó»¨Ô°

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



·¹ýµÄ

·¹ý¡£½Ó·Ö¡£

.  û·Ö Äã½Ó¸öɶ

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

...

ÀϵÄÀ´ÁË

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

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

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

1

0

½øÀ´±¨µÀ


±»Æ­ÁË

Õâ¸ö´ÊºÜÊ ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [4283] [4284] [4285] [4286] 4287 [4288] [4289] [4290] [4291] [4292]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ