How to add a file to a table in MS SQL Server

Question

As the title, Now I have a table to save data, type of data is file. But I don't know how to do that. Who can help me ?

I'm using C# (VS 2010, MS SQL Express 2005).

Thanks.

check blob type of column in sql.http://technet.microsoft.com/en-us/library/cc917636.aspx — sgud, Oct 21 '12 at 08:59
@sgud : I dont see this type in MS SQL ??? http://i206.photobucket.com/albums/bb108/voquanghoa/SQL.png — Võ Quang Hòa, Oct 21 '12 at 09:05

score 1 · Accepted Answer · answered Oct 21 '12 at 09:02

1

Read the file(s) in binary form in your C# code and store it in your table column with datatype varbinary(MAX)

answered Oct 21 '12 at 09:02

Vinod Vishwanath

1 Answers1