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
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÐèÇóÈçÏ£º
ѧԺ 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ºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
ÈçºÎ´ÓÒDZíÖн«¸ù¾ÝÈÕÆÚ²éѯµÄ½á¹û°´×îÐÂʱ¼ä£¨ÏñÐÂÎÅÄÇÑù£©µÄ·½Ê½ÅÅÁгöÀ´
(²»Òª¸ß¹ÀÄãµÄººÓï±í´ïÄÜÁ¦»òÕßÎҵĺºÓïÀí½âÄÜÁ¦)
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á ......