SQL Server – What Do Precision and Scale Mean in the Design Table Dialog

These properties apply to the numeric and decimal data types.
This useful tutorial provides us with the answer as to what they do:

the Precision number controls the maximum number of digits on the left side of the period. The Scale factor specifies the maximum number of digits used on the right side of the period.

[tags]SQLServer, MSSQL, MSSQLServer, Sql Server, Precision, Scale, Data Types, Design table[/tags]

Posted by Greg Pinero (Primary Searcher) on Aug 31st, 2006 and is filed under win32.

Both comments and pings are currently closed.

Add this post to Del.icio.us - Digg

Comments are closed.