Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQLSERVER ×Ö·û´®±í´ïʽ - MS-SQL Server / ÒÉÄÑÎÊÌâ

SQLSERVER ÎÒÓÐÒ»¸ö±í£¬²é³öÀ´µÄÒ»¸ö×Ö¶ÎÊÇ×Ö·û´®±í´ïʽ
±ÈÈç
a b c 5*6-3
a be ce 15*(6-3)
a b c 36-3
a be ce 1*(9-8)

ÎÒÏëÔڴ˺óÃæÔö¼ÓÒ»ÁÐ×ֶΣ¬°Ñ¼ÆËã½á¹ûÊä³öÀ´£¬
a b c 5*6-3 27
a be ce 15*(6-3) 45
a b c 36-3 33
a be ce 1*(9-8) 1

ÈçºÎÓÃSQL»òÕß´æ´¢¹ý³ÌʵÏÖÄØ£¿ÓÐûÓбȽϼòµ¥µÄ·½·¨ÊµÏÖÄØ£¿Ð»Ð»
SQL code:
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([col1] varchar(1),[col2] varchar(2),[col3] varchar(2),[col4] varchar(8))
insert [tb]
select 'a','b','c','5*6-3' union all
select 'a','be','ce','15*(6-3)' union all
select 'a','b','c','36-3' union all
select 'a','be','ce','1*(9-8)'

declare @sql varchar(8000)
select
@sql=isnull(@sql+' union all ','')
+'select '''+col1+''' as col1,'''+col2+''' as col2,'''+col3+''' as col3,'''+col4+''' as col4,'+col4+' as col5 '
from tb
exec (@sql)

/**
col1 col2 col3 col4 col5
---- ---- ---- -------- -----------
a b c 5*6-3 27
a be ce 15*(6-3) 45
a b c 36-3 33
a be ce 1*(9-8) 1

(4 ÐÐÊÜÓ°Ïì)
**/


SQL code



Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.Code


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......

mysqlÇøÃ»¸ßÊÖ - MS-SQL Server / »ù´¡Àà

ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......

ÇóÒ»sqlÓï¾ä - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÈçºÎ´ÓÒDZíÖн«¸ù¾ÝÈÕÆÚ²éѯµÄ½á¹û°´×îÐÂʱ¼ä£¨ÏñÐÂÎÅÄÇÑù£©µÄ·½Ê½ÅÅÁгöÀ´
(²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦)
  ½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ