Photo and image management

• Emanuel Villa

  SSC Enthusiast

  Points: 141

  More actions

  November 3, 2005 at 6:30 pm

  #88474

  Hi friends... I want to make a SQL database that can insert update and delete images and photos, imagine that You have a students table and I need a field call Photo, How I can get it? What data type I have to use? How I make de Inserts or Updates to this field?

  Thanks in advance

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 4, 2005 at 12:45 am

  #602291

  Check this out: http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

  Usually you would use the IMAGE datatype, however, when you start this new database directly on SQL Server 2005 use VARBINARY(MAX), since IMAGE will deprecate in some future version of SQL Server.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]