Int column can't accept value greater than 1112052868 , what can i do now ?
hello have problem :d , have code
sub updatestats(byval clientuid as integer, byval timestamp as datetime) clientuid = cint(timestamp.tostring("yymmdd") & clientuid.tostring())
......................
clientuid number 1112052868 , error arithmetic operation resulted in overflow if change this
sub updatestats(byval clientuid as string, byval timestamp as datetime) clientuid = timestamp.tostring("yymmdd") & clientuid.tostring()
it works stucks @ insert query error
the conversion of varchar value '111205183324' overflowed int column
yes column int , it's someone's else work , want fix it... there solution ? tried with convert.toint64(clientuid) @ insert query doesn't work...
any solutions ? thanks
thanks answering , if try alter table , loose data ?
no, you not loose data if alter column data type varchar(20)
SQL Server > SQL Server Express
Comments
Post a Comment