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
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
µã»÷¡°·þÎñ¹ÜÀíÆ÷¡±£¬µã»÷¡°¿ªÊ¼/¼ÌÐø¡±£¬×ÜÊÇÏÔʾ¡°ÓÉÓڵǼʧ°Ü¶øÆô¶¯·þÎñ¡±£¬È»ºóÔٴγö´í£¬²»Äܹ»½øÈ룬Ҳ²»Äܹ»²é¿´ÊôÐÔ£¬ÇëÎÊ´ó¼Ò¸ÃÔõô°ì£¿
ÎÒÊDzſªÊ¼Ñ§Ï°Êý¾Ý¿â£¬ÇëÎÊ´ó¼ÒÓÐûÓÐʲôºÃһЩµÄ½¨Òé»òÕ ......
Óöµ½µÄÏÖÏóÊÇ Í¬Ò»¸ö±íµÄquery»á×èÈûupdate
sql query ºÍupdate ²Ù×÷ query»á×èÈûupdate²Ù×÷Âð
Ôõô½â¾ö
ÊDz»ÊÇʲôÉèÖò»¶Ô»¹ÊÇÔõµÄ
Èç¹û»áµÄ»°£¬ÄÇͬһ¸ö±íµÄƵ·±query and ......
ÄÄλ¸ßÊÖÌṩһ¸öSQlÓï¾ä£¬¿ØÖƱíÖÐÖ¸¶¨ÁеÄÖµ±ØÐëÊÇÕýÊý£¿
ÔÚ³ÌÐòÀïÃæÅжϲ»ºÃÂ𣿣¿
Äã¿ÉÒÔÔÚ½¨±íµÄʱºòÓÃcheckÔ¼Êø±íÖеĸÃ×Ö¶Îѽ£¡
È磺
create table tab_name£¨
name varchar2(20),
age numbe ......