Try order the text in int form in MSSQL

seems mssql does not have anything try catch situation
when we want to sort a string column containing integer / double

e.g.
If we sort, 1, 5, 23. it will becomes
1
23
5

however, we can perform that using Convert(column, int). But ..... if there is a row which is a non numeric integer, then a error will be happened....

Read more »

ZPAD

因為ADSENSE 再一次REJECT 了REQUEST
所以良久沒有UPDATE 了

前幾日手痕買了ZPAD 同一個藍牙GPS
今朝醒來時, 突然間覺得 好唔抵,點解唔買IPAD .....


LOL .......