Skip to main content
1 of 4
scottm
  • 28.7k
  • 22
  • 109
  • 161

How can I insert binary file data into a binary SQL field using a simple insert statement?

I have a MSSQL 2000 server with a table containing a binary field. How do I insert the binary data of a file into that field?

CREATE TABLE Files
(
  FileId int,
  FileData binary(max)
)
scottm
  • 28.7k
  • 22
  • 109
  • 161