Insertion of documents and images

To store documents or images in your database, you can write an application that reads the contents of the file into a variable, and supplies that variable as a value for an INSERT statement.

You can also use the xp_read_file system procedure to insert file contents into a table. This procedure is useful if you want to insert file contents from Interactive SQL, or some other environment that does not provide a full programming language. DBA authority is required to use this procedure.

Example

In this example, you create a table, and insert an image into a column of the table. You can perform these steps from Interactive SQL.

Create a table to hold images.

CREATE TABLE Pictures
( C1 INT DEFAULT AUTOINCREMENT PRIMARY KEY,
   Filename VARCHAR(254),
   Picture LONG BINARY );

Insert the contents of portrait.gif, in the current working directory of the database server, into the table.

INSERT INTO Pictures ( Filename, Picture )
VALUES ( 'portrait.gif',
   xp_read_file( 'portrait.gif' ) );

Insertion of documents and images

Example

See also