sqlÁ½Áкϲ¢ÏÔʾ£¿
²éѯ½á¹û¼¯£º
ps online totle
a 0 10
b 1 11
c 5 8
ÏëÏÔʾ³ÉÕâÑù
ps exp
a (0)|(10)
b (1)|(11)
c (5)|(8)
ÈçºÎдsql
SQL code:
select
ps,
'('ltrim(online)+')|('+ltrim(totle)+')' as exp
from
tb
SQL code:
select ps , exp = '(' + cast(online as varchar) + ')|(' + cast(total as varchar) + ')' from tb
SQL code:
select ps,exp='('+cast(online as varchar(10))+')|('+cast(totle as varchar(10))+')' from ±í
SQL code:
--> ²âÊÔÊý¾Ý£º@tb
declare @tb table([ps] varchar(1),[online] int,[totle] int)
insert @tb
select 'a',0,10 union all
select 'b',1,11 union all
select 'c',5,8
select ps,exp='('+ltrim(online)+')'+'('+ltrim([totle])+')' from @tb
/*
ps exp
---- ----------------------------
a (0)(10)
b (1)(1
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
listidÊÇintÊý¾Ý
declare @listid nvarchar(100)
set @listid='(1,2,3,7,9,10)'
select * from forums where listid in(@listid)ʱÌáʾÈçÏ´íÎó£º
ÔÚ½« nvarchar Öµ '(1,2,3,7,9,10)' × ......
INSERT INTO StudAchieve(studID,studName)
VALUES('2','abc'),('2','bcd'),('2','cde')
Æ´Á˰ëÌìÒ²²»¶Ô£¬¼°°¡ ¡£¡£¡£¡£
SQL c ......
Óöµ½µÄÏÖÏóÊÇ Í¬Ò»¸ö±íµÄquery»á×èÈûupdate
sql query ºÍupdate ²Ù×÷ query»á×èÈûupdate²Ù×÷Âð
Ôõô½â¾ö
ÊDz»ÊÇʲôÉèÖò»¶Ô»¹ÊÇÔõµÄ
Èç¹û»áµÄ»°£¬ÄÇͬһ¸ö±íµÄƵ·±query and ......
±ÈÈç ÎÒÓÐÒ»¸ö±í bumen
ÀïÃæ ÓÐÒ»¸öÁÐ quanxian
id name quanxian
1 a 001;002;003;
2 b 002;003;
3 ......