SQL Server datatype Int

Question

I'm using SQL Server 2012 and I'm trying to insert values in an int column (Filenum)

INSERT INTO Tbl (Filenum, Fname, Sname, Tname, Lname, DOB, NatID, SexID, AdrsCtryID, AdrsStateID, AdrLin1, FileStatID, MarStatID, OcupID, Email, SSnum, Passnum, TelMob, TelLnd, TelWrk, TelWrkExt, TelInt, strno, Direction, AptNo, locality, adminLvl, postalcode, Contr, UsrID, LogID)
VALUES (@FileNum, @Fname, @Sname, @Tname, @Lname, @DOB, @NatID, @SexID, @AdrsCtryID, @AdrsStateID, @AdrLin1, @FileStatID, @MarStatID, @OcupID, @email, @SSnum, @Passnum, @TelMob, @TelLnd, @TelWrk, @TelWrkExt, @TelInt, @strno, @Direction, @AptNo, @locality, @adminLvl, @postalcode, @Contr, @UsrID, @LogID)

Values like (777777777) with 9 digits are allowed whereas 10 digit values give me this error

The changed value in this cell was not recognized as valid .net framework data type int32

Any idea why?

actually I encrypt it and save it, yes, could you please correct me here if I m compromising — JSON
– JSON, Commented May 23, 2017 at 19:04

SqlZim · Accepted Answer · 2017-05-23 18:55:27Z

3

max size for 4 byte signed integer: 2147483648

Try using a bigint in sql server, and a 64bit signed int long in .net.

Reference:

edited May 23, 2017 at 18:55

answered May 23, 2017 at 18:53

SqlZim

38.2k6 gold badges45 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JSON Over a year ago

thanks for the promot help... I m using this field as a primary key,,, based on my humble knowledge, int are the best to be used as primary key in relational dbs, am i correct?

SqlZim Over a year ago

@AhmadAbuMaizar It is a good clustering key (primary key is clustered by default in sql server), yes. bigint will be fine too. Ever-increasing clustering key – the Clustered Index Debate……….again! - Kimberly Tripp

JSON Over a year ago

Thank you all so much, I really appreciate any input on how to save SSN efficiently

Collectives™ on Stack Overflow

SQL Server datatype Int

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related