BLOB

Hi all!
I want to save some .exe files in a database, but I dont get this BLOB thing
:)
How do I declare a BLOB in the database table and as a variable in a stored
procedure?
Regards
MarreBLOB (Binary Large OBject) is a general term. You will find no data type in
SQL that is a blob per say. Depending on the version of SQL, you should be
using an "image" field (2000) or varbinary(MAX) in SQL 2005.
-Andrew
"Marre" <news@.supremelink.se> wrote in message
news:uPTPLqS4FHA.1864@.TK2MSFTNGP12.phx.gbl...
> Hi all!
> I want to save some .exe files in a database, but I dont get this BLOB
> thing :)
> How do I declare a BLOB in the database table and as a variable in a
> stored procedure?
>
> Regards
> Marre
>|||Hi Andrew!
Thanx for youre answer! As I understand it, i can use binary and varbinary
for files up to 8kb and if I want to work with larger files, I should use
Image.
Does this sound right to you?
Regards
Marre
"Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
news:ugA$rmV4FHA.1276@.TK2MSFTNGP09.phx.gbl...
> BLOB (Binary Large OBject) is a general term. You will find no data type
> in SQL that is a blob per say. Depending on the version of SQL, you should
> be using an "image" field (2000) or varbinary(MAX) in SQL 2005.
> -Andrew
> "Marre" <news@.supremelink.se> wrote in message
> news:uPTPLqS4FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> Hi all!
>> I want to save some .exe files in a database, but I dont get this BLOB
>> thing :)
>> How do I declare a BLOB in the database table and as a variable in a
>> stored procedure?
>>
>> Regards
>> Marre
>|||Yes.
Image and VARCHAR(MAX) / VARBINARY(MAX) have a performace hit. Store it in a
varbinary(8000) if you can.
-A
"Marre" <news@.supremelink.se> wrote in message
news:%23awky%23f4FHA.3276@.TK2MSFTNGP10.phx.gbl...
> Hi Andrew!
> Thanx for youre answer! As I understand it, i can use binary and varbinary
> for files up to 8kb and if I want to work with larger files, I should use
> Image.
> Does this sound right to you?
> Regards
> Marre
> "Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
> news:ugA$rmV4FHA.1276@.TK2MSFTNGP09.phx.gbl...
>> BLOB (Binary Large OBject) is a general term. You will find no data type
>> in SQL that is a blob per say. Depending on the version of SQL, you
>> should be using an "image" field (2000) or varbinary(MAX) in SQL 2005.
>> -Andrew
>> "Marre" <news@.supremelink.se> wrote in message
>> news:uPTPLqS4FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> Hi all!
>> I want to save some .exe files in a database, but I dont get this BLOB
>> thing :)
>> How do I declare a BLOB in the database table and as a variable in a
>> stored procedure?
>>
>> Regards
>> Marre
>>
>|||Thank you for helping me out here!
/Marre
"Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
news:%23zaMkhn4FHA.472@.TK2MSFTNGP15.phx.gbl...
> Yes.
> Image and VARCHAR(MAX) / VARBINARY(MAX) have a performace hit. Store it in
> a varbinary(8000) if you can.
> -A
> "Marre" <news@.supremelink.se> wrote in message
> news:%23awky%23f4FHA.3276@.TK2MSFTNGP10.phx.gbl...
>> Hi Andrew!
>> Thanx for youre answer! As I understand it, i can use binary and
>> varbinary for files up to 8kb and if I want to work with larger files, I
>> should use Image.
>> Does this sound right to you?
>> Regards
>> Marre
>> "Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
>> news:ugA$rmV4FHA.1276@.TK2MSFTNGP09.phx.gbl...
>> BLOB (Binary Large OBject) is a general term. You will find no data type
>> in SQL that is a blob per say. Depending on the version of SQL, you
>> should be using an "image" field (2000) or varbinary(MAX) in SQL 2005.
>> -Andrew
>> "Marre" <news@.supremelink.se> wrote in message
>> news:uPTPLqS4FHA.1864@.TK2MSFTNGP12.phx.gbl...
>> Hi all!
>> I want to save some .exe files in a database, but I dont get this BLOB
>> thing :)
>> How do I declare a BLOB in the database table and as a variable in a
>> stored procedure?
>>
>> Regards
>> Marre
>>
>>
>|||Can you give more info on the performance hit?
Thanks.
"Andrew Robinson" wrote:
> Yes.
> Image and VARCHAR(MAX) / VARBINARY(MAX) have a performace hit. Store it in a
> varbinary(8000) if you can.
> -A
> "Marre" <news@.supremelink.se> wrote in message
> news:%23awky%23f4FHA.3276@.TK2MSFTNGP10.phx.gbl...
> > Hi Andrew!
> >
> > Thanx for youre answer! As I understand it, i can use binary and varbinary
> > for files up to 8kb and if I want to work with larger files, I should use
> > Image.
> >
> > Does this sound right to you?
> >
> > Regards
> > Marre
> > "Andrew Robinson" <nemoby@.nospam.nospam> wrote in message
> > news:ugA$rmV4FHA.1276@.TK2MSFTNGP09.phx.gbl...
> >> BLOB (Binary Large OBject) is a general term. You will find no data type
> >> in SQL that is a blob per say. Depending on the version of SQL, you
> >> should be using an "image" field (2000) or varbinary(MAX) in SQL 2005.
> >>
> >> -Andrew
> >>
> >> "Marre" <news@.supremelink.se> wrote in message
> >> news:uPTPLqS4FHA.1864@.TK2MSFTNGP12.phx.gbl...
> >> Hi all!
> >>
> >> I want to save some .exe files in a database, but I dont get this BLOB
> >> thing :)
> >>
> >> How do I declare a BLOB in the database table and as a variable in a
> >> stored procedure?
> >>
> >>
> >> Regards
> >> Marre
> >>
> >>
> >>
> >
> >
>
>|||"yluo" <yluo@.plexus-group.net> wrote in message
news:0818E574-53A7-4936-9C36-CA8BC3F2B957@.microsoft.com...
> Can you give more info on the performance hit?
> Thanks.
>
> "Andrew Robinson" wrote:
>> Yes.
>> Image and VARCHAR(MAX) / VARBINARY(MAX) have a performace hit. Store it
>> in a
>> varbinary(8000) if you can.
>> -A
A varbinary(8000) column will live on the data page itself as part of the
row.
VARCHAR(MAX) and VARBINARY(MAX) will use BLOB objects. In the row itself,
a 16-byte pointer will now point at separate data pages which store the BLOB
object.
That = more reads, possibly more unused space etc.
Rick Sawtell
MCT, MCSD, MCDBA