Please i need help with this line, been giving headache for hours.
Error i get is Incorrect syntax near 'ChurchPhoto'Code:insert into tblPicture1 (AcctNo, MCard,FileName) SELECT '900901', * FROM Openrowset( Bulk 'C:\MyFiles\Media\Photo14061004777.JPG', Single_Blob) as img,'ChurchPhoto'
Please help.
The table tblPicture1 has the following structure:
[AcctNo] [nvarchar](50) NULL,
[MCard] [image] NULL,
[FileName] [nvarchar](50) NULL
Thanks.




Reply With Quote
