June 17, 2003 09:17 PM

BLOB Access Technologies

Rating: (0)
SQL Server Magazine
InstantDoc ID #39058
SQLServer typically stores binary large object (BLOB) data, such as graphics and sounds, as native text, ntext, or image data types. Microsoft provides several tools for working with BLOBs, and you can find extensive information about these tools in the Microsoft Knowledge Base. Here are seven of the most important access technologies for working with BLOBs in SQL Server.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

BII does not use the Bulkcopy API, it uses a regular insert using a parameterized insert with ODBC.
-GertD

Gert Drapers 7/24/2003 4:36:42 PM


You forgot ADO.NET's ExecuteNonQuery method - an excellent means to upload data if you do not need the overhead of a dataset.

I use it for uploading image data. I just pass the image parameter as a byte array. Works like a charm.

Robert Frostad 6/20/2003 12:37:42 PM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS