Sunday, March 25, 2012

Difference between dataTypes in SQL 2005?

What is the difference between binary and image dataType.

When and how should I use them?Hello,

Here is difference between binary and image data type.
BINARY: Fixed-length binary data with a maximum length of 8,000 bytes
IMAGE: Variable-length binary data with a maximum length of 2^31 - 1 bytes

You can use them accordingly...

No comments:

Post a Comment