Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Query and modify data » Data manipulation statements » Addition of data using INSERT

 

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
 See also