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

added 6 characters in body; edited tags

Source Link

edited Jun 6, 2013 at 9:36

759.6k
185
1.4k
1.5k

I have a MSSQLSQL Server 2000 server with a table containing an image fieldimage column.

How do I insert the binary data of a file into that fieldcolumn by specifying the path of the file?

CREATE TABLE Files
(
  FileId int,
  FileData image
)

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

CREATE TABLE Files
(
  FileId int,
  FileData image
)

I have a SQL Server 2000 with a table containing an image column.

How do I insert the binary data of a file into that column by specifying the path of the file?

CREATE TABLE Files
(
  FileId int,
  FileData image
)

edited tags; edited tags

Link

edited Jul 14, 2009 at 15:36

GEOCHET

21.3k
15
78
99

mssql2000 t-sql sql-server

added 35 characters in body; deleted 6 characters in body; edited body

Source Link

edited Jul 13, 2009 at 16:58

scottm

28.7k
22
109
161

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

CREATE TABLE Files
(
  FileId int,
  FileData binary(max)image
)

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)
)

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

CREATE TABLE Files
(
  FileId int,
  FileData image
)

Source Link

asked Jul 13, 2009 at 16:47

scottm

28.7k
22
109
161

Loading

Collectives™ on Stack Overflow

Return to Question