SQL Server - What data type should I use to store binary data?

By [)ia6l0 iii

Use Binary or VarBinary fields to store fixed or variable length. These were available in 2005 and 2008 versions only.

The Image datatype is depreciated.

Related FAQs

11g provides the following new features over 10g
Normalization in databases refers to representing data in a manner with least representation so that its accessible in all the ways.
Find if a table has a Clustered Index using the Information_Shcema tables.
The error means that you attempted to truncate a table with unique/primary key that is referenced as foriegn key in another table.
Varchar can store non-Unicode character data where as nvarchar can store Unicode character data.
User Defined functions can be used inside a Select clause or a conditional statement such as Case. It can also be used in filtering statements such as Where. User Defined functions need to return a value, where as Stored procedures may not return. Stored are pre-compiled unlike the functions that are compiled at runtime.
SQL Server - What data type should I use to store binary data?  (1232 Views)