Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Datatype to store images and files in sql server

 
Naj Syl
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can anyone please tell us about the datatype used to store images and files(pdf,word files) in sql server...
Also if possible gv us the snippet of how to store using ASP code...
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Storing binary files in the database is (in my opinion) a bad idea. But if you are sure you want to do this the datatype for SLQ Server will be IMAGE.

For ASP code, I suggest you ask in a Microsoft forum. Unfortunately we don't have any here, but I'm sure you'll find the information you need at MSDN.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic