Viewing 10 posts - 1 through 11 (of 11 total)
Jeff
Yes they are working fine if you run following individually as you said. But When I am executing using EXEC ( @SQLstr) I am facing problem.
INSERT INTO dbo.MyFiles...
July 25, 2011 at 8:19 am
Do you know how I can force to accept following name in above query which contains comma
18765_McHaney,Packet,DI,4.2.10_1
July 24, 2011 at 5:53 pm
No. Because files names already exists in the database, I guess they were inserted by Front end Application. Basically it holds names and paths to the files on the disk....
July 24, 2011 at 5:30 pm
No I didn't help yet. I wanted load first whatever I can. Thought I could revisit those files. Now I have another character comma(,) also in the file names.
July 24, 2011 at 4:37 pm
Sorry no luck yet, see below
INSERT INTO dbo.MyFiles(OrignalFileName,FileName,CreationDate,file_blob)
SELECT '07/14/2011 11:20 AM 31,232 ton_ula_ula''sMarch19,2011_2.doc',
'ton_ula_ula''sMarch19,2011_2.doc',
'Jul 14 2011 12:00AM',
*
FROM...
July 23, 2011 at 2:51 pm
I observed you inserted another apostrophe near '. You can do that if you know the file name. Bu tin my case they are dynamic,Files names are supplied...
July 23, 2011 at 2:21 pm
Jeff,
those are not real file names, they are edited for privacy. Just they are not real. But real file names also consists these kind of characters. They are done by...
July 23, 2011 at 2:09 pm
Jeff
I did as you said as following, see error in second box
FROM OPENROWSET(BULK "''D:\DOCS2011\'+ @FileName + ''' ", SINGLE_BLOB) AS imagesource'
Just I used PRINT statement to get what...
July 23, 2011 at 1:29 pm
Viewing 10 posts - 1 through 11 (of 11 total)