星期一, 2月 14, 2011

欄位為nvarchar欄位,依據排序並非可以得到預期結果,若以數字(nvarchar)為排序將會以字串方式作排列。

尚未做處理之排序結果如:

select 彩劵號碼 from dbo.Lucky

select 彩劵號碼 from dbo.Lucky

order by

(case ISNUMERIC(彩劵號碼) when 1 then STR(彩劵號碼,10)else 彩劵號碼 end)

參考來源:http://www.dotblogs.com.tw/621122/archive/2011/02/11/21339.aspx

星期三, 4月 22, 2009


Greedy mind will be fell in hell
Last Saturday,I with my greduate classmate chating in the unyummy meal pesta resturant.My classmate is my best classmate and friend.Everything happenning he told me at first.He is my teacher and also my friend.My point had changed when chated with him last Saturday.He was became greedy mind cash and money in his first view.He was fell with in other female friend who she came from Mainland China and she was marred in Taiwan.Her job so abnormal.My friend said many many excusecover his hypocritical mind.Is it possible that he was forggten he still has ture girl friend for now?He was steal intelligent property in his company whichtransfer to other competition company thus he will get bundle of dirty cash.I did't know what can I said ?Let me mercy to him that actually said shame on him.

星期四, 3月 05, 2009


The Day the Earth Stood Still,that the Keanu Reeves actors latest moive since last year.The moive title proved the earth getten worse slowly.How to said?Before Britsh encountered nearly twenty years hardest damaged from the snow storm.The temperture got down the subzero twenty centigrade,whith everywhere disaster very horrible.Every could be happend and include of receesionin the world.Although the economy very worse but to besupposed to do enjoy your life continum and keep your step."Whatever the economy worse deeply need to do just need to do" by advisor when I was a graduate student.

星期四, 2月 05, 2009

Some people said "Time flies",witch it absolutily ture.End up the Chinese Lunar year and totally nine days in vacation,that mamy without working days then continue go work let me
unavoidable felt unhappy and some got with it yet.Whatever I should stronger and enjoying
this job at present.Although I may went out the job when contract off,that I deeply cherish to I own the job at present.Thanks everyone if you ever help me.


星期五, 1月 23, 2009

Year-end party

Last Wenseday my customer service had taken place the year-end party,which it my first the year-end party in civil department and it final the year-end party of mine in civil department.Held on drawing for prizes during the year-end party.Totally thouand of prizes but I hadn't gotten anyone prizes,that some a little dispointment.It was drawing again after the year-end party,that I thought our unit for everyone gotten prizes.To have great cause for rejoicing both I and my father gotten prizes which it was so intersting.My father and me drawing the same prizes.

星期二, 1月 13, 2009

Between you and me within economy crisis during last year the end and this or next year.Many company were lay off that saved whole execution by themself.Reportedly,lay off population near 200 million people in the world.No matter what,keep status up by yourself.We were await blooming economy or not?