Storing large files in a table

• VikramMullick

  SSC Enthusiast

  Points: 167

  More actions

  November 11, 2005 at 3:44 am

  #88488

  Hi ,

     I want to store large files in a table.I am using SQLserver 2000

  and working on vb.net . Should i pass file contents as input variables to the stored procedure or my stored procedure should

  read the file content itself before inserting the data inside the table.

   Files are both of type text as well XML.

  Let me know which approach is more feasible and how do it.

  Later i also need to read contents of the file from the table.

  Regards,

   Vikram

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  November 11, 2005 at 2:30 pm

  #603521

  Look up Text datatype in books online, they are different data types and take additional design and management requirements.

  From books online about text:

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_13_8orl.asp

  I would pass the file information in to procedure thru parameter as t-sql has inadequate methods to read from disk.

  But I usually avoid storing large binary and text objects into a database.