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 |
|
jessiefun
Starting Member
35 Posts |
 Posted - 2010-11-29 : 21:50:06
|
I have some confusion about the basic things  and here is the thing - For int - the default length in sql server is 4 bytes and the data from 2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). which should be 2^(4*8-1) through 2^31(4*8-1)-1. while for image type, the default length is 16 bytes, while if the image is much larger than 16 bytes, then how does database store them? This should be like the address thing - which i mean, here in image column, it just stores the pointer of the image, right? Thanks, Jessie |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2010-11-29 : 21:52:10
|
| Correct.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.9 out!SQL Server MVP |
 |
|
|
jessiefun
Starting Member
35 Posts |
Posted - 2010-11-29 : 23:25:39
|
quote:
Originally posted by spirit1
Correct.___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.9 out!SQL Server MVP
Thanks a lot Spirit |
|
|
|
|
|
|
|
|
Length of datatype