Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paritosh
Starting Member
42 Posts |
 Posted - 2011-08-30 : 07:15:59
|
| what is lenght when we define numeric data type precision & scale .for example id numeric(2,0) 2 is precision 0 is scale when select table and press alt+f1 then show lenght, precision & scale |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-08-30 : 08:05:23
|
| It is telling you how many bytes are used for storing. This page has info on storage for decimal data type (which varies with precision) |
 |
|
|
paritosh
Starting Member
42 Posts |
Posted - 2011-08-31 : 03:39:34
|
| thanks for answer |
|
|
|
|
|
|
what is length