asked on

SP_Help Prec = 10

I ran SP_Help and the Prec column for my ID field equaled 10

What does this mean?

Guy Hengel [angelIII / a3]

what is the data type?

Mr_Shaw

ASKER

int

Mr_Shaw

ASKER

Here is my output

Column_name: ID
Type:      int
Computed:      no
Length:      4
Prec:      10
Scale:      0
Nullable:      no
TrimTrailingBlanks:      (n/a)
FixedLenNullInSource:      (n/a)
Collation:      Null

tigin44

If sp_help is executed with no arguments, summary information of objects of all types that exist in the current database is returned.

so you have 10 objects in the db you are running this query.

ASKER CERTIFIED SOLUTION

tigin44

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mr_Shaw

ASKER

Sorry the exlpanation you gave were a little to techi more me.

I ran sp_help[Table_Name] to return some more information about my table.

ID is just one field from my table.

SOLUTION

Guy Hengel [angelIII / a3]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tigin44

prec indicates the total number of digits.. In your case the data type is int and you can store a 10 digit number in that column...
if the column type to be float then the prec value would be 53 meaning that you can store 53 digit number including the point and the decimal place..

SOLUTION

sureshchsahu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mr_Shaw

ASKER

thanks