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 ¶¨ÒåÄ ......
ÏÖÔÚÓÐ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 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 ......
A±í£¨Ö÷±í£©
A1£¨Ö÷¼ü£© A2
1 ÕÅÈý
B±í
B1£¨Íâ¼ü£© B2
1 ZHONG
1 GUO
C±í
C1£¨Íâ¼ü£© C ......
[Excel Ô´ [1]] ´íÎó: Êä³ö¡°Excel Ô´Êä³ö¡±(9) É쵀 Êä³öÁС°Description 3¡±(546) ³ö´í¡£·µ»ØµÄÁÐ״̬ÊÇ:¡°Îı¾±»½Ø¶Ï£¬»òÕßÒ»¸ö»ò¶à¸ö×Ö·ûÔÚÄ¿±ê´úÂëÒ³ÖÐûÓÐÆ¥ÅäÏî¡£¡±¡£
¸ÃÁÐÔÚexcelÖÐ×Ϊ308¸ö×Ö·û£¬µ«ÊÇexcelÔ´ÖеÄÍⲿÁкÍÊä³öÁÐ×î¶àÖ»ÄÜÉèΪNvarchar(255),Èç¹ûÉ趨³¤¶È³¬¹ý255£¬Ôò³öÏÖ¾¯¸æ£¬Ô´ÁÐÊôÐÔ²»Æ ......
¾ÍÏë¿´¿´¶àÉÙÈ˽øÀ´£¡
¿´¿´ºó»¨Ô°Õâ¸ö´ÊºÅÕÙÁ¦Óжà´ó£¬±¾ÌùÊÇÎÞÁÄÌù~~~~~~~~
.
·¹ýµÄ
·¹ý¡£½Ó·Ö¡£
. û·Ö Äã½Ó¸öɶ
ºó»¨Ô°Íϵع¤Æ®¹ý
...
ÀϵÄÀ´ÁË
ÎÒÒ²ÏëÈ¥Íϵأ¡
ÎÒÒ²ÏëÈ¥Íϵأ¡
進來²È個腳Ó¡¡£¡£
1
0
½øÀ´±¨µÀ
±»ÆÁË
Õâ¸ö´ÊºÜÊ ......