ID Name Password 1 abcd 111111 2 wer 222222 3 dsf 1234 4 fgty 5555 5 ghyu 77777 6 hhnj 666666 7 gggbv 99999 8 eert 8888888 9 fvgb 0000000 10 hjuik 3232323 11 erwq 45455 12 sdfgh 4565656 13 wewe 4545656 14 sdcvf 65656 15 wwwer 565656 16 fgbgh 6566 17 ertyu 6566
varchar
int
select max(CAST(id as int)) from BadDesignedTable
SELECT CONVERT(INT,[ID]) AS IDS FROM USER
@@identity
SELECT MAX(Id) FROM User
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)