You should read the whole thread first because it has been answered years ago.

I didn't use embedded sp_fkeys procedure there.

I did everything using the pure joins. 🙂

Heck... I wrote it - one year ago. lol

Thanks guys. Although it has a low rating here 😀 it really did save lots of time for me.

We had a bunch of tables which needed this kind of intervention...

Robert (8/28/2008)

---

I'm also having trouble implementing this without corruption of the file after it's undergone a round trip. I am importing a text file using OPENROWSET and as far...

Robert (8/29/2008)

---

Errrrrr this line is too long. You could've shown me at least the code

of the create table I would've believed you.

I've just tried even to dump the mp3...

Errrrrr this line is too long. You could've shown me at least the code

of the create table I would've believed you.

I've just tried even to dump the mp3 and...

Here is what I did.

create table data(data varchar(max));

INSERT INTO data(data)

SELECT * FROM

OPENROWSET(BULK 'D:\docs\DB\oracle.txt', SINGLE_BLOB) as f ;

declare @cmd varchar(512);

SET @cmd...

varchar(max) != varbinary(max)

The varbinary(max) can store upto 2GB data.

You can...

Robert (8/28/2008)

---

I'm also having trouble implementing this without corruption of the file after it's undergone a round trip. I am importing a text file using OPENROWSET and as far...

Show me the contents of your bindata table

select top 1 * from bindata.

Well what I've just done for testing purposes:

CREATE TABLE data(data varbinary(max));

INSERT INTO data(data)

SELECT...

Comments are always welcome especially if they're the way to improve. 🙂

Thanks alot it works perfect too.

Well as I wrote there were many ways to improve. 🙂

What is your exact command for the retrieving of the image file and how does your data table look like?

Show me please your sp_help 'your_table' output.

thanx