Getting numeric precision in case of int datatype of SQL Server

Question

I am fetching following details of columns from SQL Server:

Size
Precision
Scale

But I have noticed that in case of int I am getting 10 as precision but when i did some research, I couldn't find any such thing related to int, and that int datatype have precision of 10 or in SQL Server Management Studio.

So I don't know how 10 is coming as precision in case of int data type.

Table:

Screenshot:

Code:

String[] columnRestrictions = new String[4];
columnRestrictions[0] = 'MyDb';
columnRestrictions[1] = 'dbo';
columnRestrictions[2] = 'Employee';

using (SqlConnection con = new SqlConnection("MyConnectionString"))
{
    con.Open();
    var columns = con.GetSchema("Columns", columnRestrictions).AsEnumerable()
         .Select
          (
                 t => new 
                 {
                     Name = t[3].ToString(),
                     Datatype = t.Field<string>("DATA_TYPE"),
                     IsNullable = t.Field<string>("is_nullable"),
                     Size = t.Field<Int32?>("character_maximum_length"),
                     NumericPrecision = t.Field<int?>("NUMERIC_PRECISION"),
                     NumericScale = t.Field<Int32?>("NUMERIC_SCALE")
                 }).ToList();

If you look at the int datatype you'll see that the largest values it can store require (up to) 10 decimal digits to represent. So if something's insisting on giving a precision for an int, it's not an unreasonable answer to provide. — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Dec 12, 2016 at 14:14
Precision is the number of digits in a number, the maximum digits in a 32 bit int is 10. (and 19 for a bigint) — Alex K.
– Alex K., Commented Dec 12, 2016 at 14:15
@Damien_The_Unbeliever :So my output is correct as 10 in case of int datatype??? — I Love Stackoverflow
– I Love Stackoverflow, Commented Dec 12, 2016 at 14:18
@TimSchmelter:Sir i would like to ask you 1 thing that why you deleted your answer on my this question(stackoverflow.com/questions/41062636/…) although it was correct.i was about to mark it as accepted answer but you deleted it — I Love Stackoverflow
– I Love Stackoverflow, Commented Dec 12, 2016 at 14:22

Jon Hanna · Accepted Answer · 2016-12-12 14:18:03Z

1

Precision refers to the number of significant decimal digits a number can represent.

The int datatype, like the int datatype in C#, can range from -2147483648 to 2147483647, so it can have up to 10 significant decimal digits.

The precision of int is therefore always 10.

answered Dec 12, 2016 at 14:18

Jon Hanna

114k10 gold badges151 silver badges258 bronze badges

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

2 Comments

Jon Hanna Over a year ago

It is, though it's not very useful. It's only really a useful datum in cases where it can vary, as in the SQL decimal datatype.

I Love Stackoverflow Over a year ago

Thank you thank you so much for helping me clearing my doubt.please keep helping like this

Collectives™ on Stack Overflow

Getting numeric precision in case of int datatype of SQL Server

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related