Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Inserting images into SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-19 : 22:26:45
Mike writes "We are migrating Access databases into SQL server and are having problems with image files. We use small signature files that are simply cut and pasted into an Access form. I have been unable to find the syntax for inserting images into SQL with a SQL statement. All I was able to find was bcp and BULK INSERT, neither of which I was able to get to work. I realize that storing images is inefficient but storing the physical paths to the files would not work because we move these images from one SQL server to other SQL servers. I am using SQL server 7.0 on Windows NT 4 SP 5."
   

- Advertisement -