<div>
what version of SQL Server are you using?
</div>


what version of SQL Server are you using?

<div>
Hi,<br />
<br />
Add a comma after the word bulk ...<br />
<br />
BULK 'c:\...\Image 32.JPG', SINGLE_BLOB<br />
<br />
Cheers<br />
&nbsp; David
</div>


Hi,

Add a comma after the word bulk ...

BULK 'c:\...\Image 32.JPG', SINGLE_BLOB

Cheers
  David

<div>
2005 Workgroup Edition, v. 8.00.2187 on NT 5.2. &nbsp;Comma doesn't seem to help. &nbsp;Do I need to use the UNC rather than the local file name?
</div>


2005 Workgroup Edition, v. 8.00.2187 on NT 5.2.  Comma doesn't seem to help.  Do I need to use the UNC rather than the local file name?

<div>
<div class="content wysiwyg-content">
Hello, I'm trying to import images from the file system into a column of data type 'image'. &nbsp;An expert pointed me to the OPENROWSET(BULK... statement, but the code below gives an error: &nbsp;Incorrect syntax near the keyword 'BUKL'. &nbsp;Any ideas why? &nbsp;The server is Microsoft SQL Server Workgroup Edition. &nbsp;Any help is appreciated.<br />

<pre><code id="code-30216">UPDATE db1.dbo.ImageValues SET Value =
  (SELECT * FROM OPENROWSET( BULK 'c:\...\Image 32.JPG', SINGLE_BLOB))
</code></pre>
</div>
</div>


Hello, I'm trying to import images from the file system into a column of data type 'image'.  An expert pointed me to the OPENROWSET(BULK... statement, but the code below gives an error:  Incorrect syntax near the keyword 'BUKL'.  Any ideas why?  The server is Microsoft SQL Server Workgroup Edition.  Any help is appreciated.

Why does this OPENROWSET(BULK... statement give an error?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.