Viewing 13 posts - 1 through 13 (of 13 total)
You should read the whole thread first because it has been answered years ago.
May 9, 2013 at 9:41 am
I didn't use embedded sp_fkeys procedure there.
I did everything using the pure joins. 🙂
Heck... I wrote it - one year ago. lol
August 31, 2009 at 2:08 am
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...
January 24, 2009 at 12:43 pm
September 15, 2008 at 4:28 pm
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...
August 30, 2008 at 2:45 am
I've just tried even to dump the mp3 and...
August 29, 2008 at 2:00 am
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);
August 29, 2008 at 1:58 am
josephstran (8/28/2008)How to I extract binary data greater than 8000 Bytes (varchar(max))? Thank you for any help you can provide.
varchar(max) != varbinary(max)
The varbinary(max) can store upto 2GB data.
August 28, 2008 at 12:26 pm
August 28, 2008 at 12:21 pm
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));
August 28, 2008 at 7:59 am
Comments are always welcome especially if they're the way to improve. 🙂
August 28, 2008 at 7:24 am
Thanks alot it works perfect too.
Well as I wrote there were many ways to improve. 🙂
August 28, 2008 at 6:58 am
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.
August 28, 2008 at 5:18 am