create image in column

Question

how can create image column that hold only imade when creating a table in SQL Server?

Muralidharan Deenathayalan · Answer

You can use Image datatype in sql server to store the images into sql server. But storing images into db is not the suggested one. MS is planning to remove image datatype in the future.  ntext  text  and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work and plan to modify applications that currently use them. Use nvarchar(max)  varchar(max)  and varbinary(max) instead.  http://msdn.microsoft.com/en-us/library/ms187993.aspx http://msdn.microsoft.com/en-us/library/ms188362.aspx http://stackoverflow.com/questions/444072/varbinary-vs-image-sql-server-data-type-to-store-binary-data