作者查詢 / sqrt1089
作者 sqrt1089 在 PTT [ Python ] 看板的留言(推文), 共7則
限定看板:Python
看板排序:
全部NTUT_EE493A312C_Sharp62home-sale62Perl59DragonNest49WarCraft48Japan_Travel46Tainan35Tech_Job34BabyMother31Gintama26MATLAB25Boy-Girl22Grad-ProbAsk18travian17GoodPregnan16joke16MenTalk15SRW15Gov_owned14Old-Games13MP12ONE_PIECE11CFP10Statistics9Python7toberich7cabala6mobile-game6NCKU-StaGS006NCKU-StaGS016Palmar_Drama6StupidClown6Database5Evangelion5Gossiping5CareerPlan4Chan_Mou4Militarylife4NSwitch4sex4Soft_Job4Thailand4car3Examination3GetMarry3GUNDAM3LoL3NTUBIME-1023Scorpio3YoungDotx33AllTogether2Broad_Band2graduate2Isayama2Lineage2movie2Q_ary2Taoyuan2Web_Design2Aries1ask1BabyProducts1BLEACH1Cancer1CarShop1Digitalhome1FishShrimp1Gamesale1Golden-Award1japanavgirls1KS91-3191marriage1NDHU-phy1011NLHS-5th-3121NUU_Talk1Pisces1PlayStation1Salary1San-Ying1SET1share1<< 收起看板(82)
首頁
上一頁
1
下一頁
尾頁
6F推: select MAX(CONVERT(INT, IndexNo)) from markTable10/05 17:39
7F→: 應該是字串問題,左邊對齊,examNO有補0所以沒問題10/05 17:41
9F→: https://i.imgur.com/U54ZheR.png10/05 17:45
10F推: 或是自己補0跟examNo一樣情境XD10/05 17:58
11F→: Select Max(Right('00000000' + Cast(IndexNo as varcha10/05 17:59
12F→: r),8)) from markTable10/05 17:59
1F→: 上網查過,大部分的文章是說要有耐心點等等就過了08/01 16:43
首頁
上一頁
1
下一頁
尾頁