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

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.
UPDATE db1.dbo.ImageValues SET Value =
  (SELECT * FROM OPENROWSET( BULK 'c:\...\Image 32.JPG', SINGLE_BLOB))

Open in new window

LVL 6
grendel777Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
grendel777Connect With a Mentor Author Commented:
Oops, I lied, this is 2000 not 2005, which means that OPENROWSET(BULK... won't work.  Sorry, I'm at a new job and made an assumption (I know, I know).  Can anyone either (a) suggest an alternative method or (b) kill me?  I've upped the points.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what version of SQL Server are you using?
0
 
David ToddSenior DBACommented:
Hi,

Add a comma after the word bulk ...

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

Cheers
  David
0
 
grendel777Author Commented:
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?
0
All Courses

From novice to tech pro — start learning today.