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
SELECT MAX(Id) FROM User
@@identity
SELECT CONVERT(INT,[ID]) AS IDS FROM USER
varchar
int
select max(CAST(id as int)) from BadDesignedTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)