欄位為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

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.

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.

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.

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.

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?

My father told the lesson to me,which totally spent half hours .Some people said:"Good advice jars on the ear".I thoutht it a little such a tureth.He told me more time "What your way in the future?"If you went to in the information technology field in the future,you should dig in the various information technology kown-how abilities.I thought father really disappointed in me.I am useless.Action without long words.I will find my courage that enhance my soul.

I felt some a little special.I with my girl friend and her family amd her sister's boy friend came toghter ate dinner in Tai Town Cuisine.This my first meet her sister's boy friend that thought I didn't talked with him but I thought he so friendly and a nice guy.After the meal her sister's boy friend and my girl friend monther was strive check.Finllay,her sister's boy friend got WON .Treat us first meal.I thought my girl frined's monther felt happy mood.


http://www.thaitown.com.tw/thai/31_tem.php?id=1

I was not went to my office yesterday.
Because I would went out the bussiness in Fourth Maintenance Office Directorate General of Highways where it localed in Suao of YiLan county.
I with my head of data manegement other my company.Included many scenic area in YiLan county.For instance,Jiaosi hot Springs. Nanfangau Fish Market and
Harbor.Suao Cold Mineral Spring.Jiaushi Park and Neighboring Areas and so on.Why am I loved the YiLan county?I was a student in here since nine year ago.
YiLan speack to me some alike secend hometown.I pretty loved here.By this went out the bussiness,that bring me many unforgettable memories when I was student in YiLan.

Finding more about sightseeing in YiLan.Surfing the website designed by yilan county government
http://tourism.e-land.gov.tw/EN/

2005遇上最冷的夏天
兩次的投搞都落空
還剩下些什麼.......
我承認..還是不夠努力
都只是想靠運氣..
拍拍身上的灰塵
只有繼續站起來的決心
而沒有輸不起的灰心~

繼續努力..

94年5月20日這天....

這天不是阿扁就職典禮,那跟我無關...
而是我的二度挑戰投稿論文的結果....
答案只有...生或死...
生,是我繼續向前的動力
死,而是我重心思考定位的教訓

盡最大的努力,做最壞的打算

相信自己...

不是懦夫

論文怎麼改都不順~
我對一篇論文整理架構組織完全都搞不懂
還想去想一篇論文~
不知老師是否有私心~
還是我真的不夠努力~
一些事情我都還不懂..
我相信沒有永遠的失敗者..
只有沒有勇氣站起來的懦夫..

悶
失落真的不是因為沒上榜而失落
而是看到父母失落而失落
怎麼..落榜就名詞總是會被我遇倒呢?
我也不能怎樣呀~選擇去面對~
投稿沒上~代表自己的努力還是不夠的
輔大--->沒了
高科---->?

進最大的努力~做最壞的打算~

go~ pip lin

有了目標
人有了目標不但有了動力也成熟了更多
知道自己想做什麼而不是荒謬過一生
就是醬~往我的目標邁進吧!!

再見了8541



2004.6.23正式跟8541伴我們近一年的歇腳地方
在這兒~我們看電影.凌晨開聊天室聊到5點.吃港都.做報告.打NBA GAME.F8-流猩雨產發地..等
下午1:50正式跟它說再見~
大家相聚住在一起已經是不太可能了
那種大夥在感覺共患難的感覺~真的很棒
我已珍惜每一刻ㄌ~不再覺的遺憾ㄌ~

有答案了
不敢相信自己的所見到的~正取13
上了我自己心中其中一所學校
百感交及~
這一路走來~顛簸不已~但堅定走下去
得到的果實真ㄉ是甜而肥美呀~
感謝~支持我ㄉ親朋好友~

有心理準備了
維期10個月的不美的夢在今天5月15日,11:42am,夢!醒了
走來崎嶇.寂寞一個人在圖書館k書.寒假12個日子中總共到圖書館k了70個小時的書
過程很辛苦結果已經不重要了,這一系列考下來知道自己的缺失在哪
勇於接受失敗的慘果,一次的失敗是下一次成功的墊腳石
失敗我可接受,但試都不試我可不接受----[Michael Jordan]
pip stand up to keep go ahead
next be more pretty

世新---X
長庚---X
北大---?
健康---?
玄奘---?

下一步怎麼走
已經有數了

期望不如預期

當對某樣事情有所期待,往往都會失落
都對某樣事情有所在乎,往往都是失望
不曉得怎麼會這樣子,往往都要讓時間來撫平傷痛

考完長庚後的心情
兩極化的考題,兩種不一樣的心情
計概幾乎都不會,會的也沒啥把握
MIS出乎意料外的簡單,很好寫
老媽說:不會寫就算了啦沒關係,反正早晚都要當兵 ,當完兵再來考呀
聽ㄌ真的很感動...
剩下三所等我去拼ㄌ..
堅持下去~