Murach's SQL Server 2008 for Developers
How to work with BLOBs

Large binary values, such as images, sound, and video, are often referred to as binary large objects (BLOBs). In this chapter, you'll learn how to use SQL and a .NET application to work with BLOBs. Then, you'll learn how to use the 2008 FILESTREAM storage feature to work more efficiently with BLOBs that are larger than 1 megabyte.
Chapter 19 How to work with BLOBs
An introduction to BLOBs 616
Pros and cons of storing BLOBs in files 616
Pros and cons of storing BLOBs in a column 616
When to use FILESTREAM storage for BLOBs 616
How to use SQL to work with a varbinary(max) column 618
How to create a table with a varbinary(max) column 618
How to insert, update, and delete binary data 618
How to retrieve binary data 618
A .NET application that uses a varbinary(max) column 620
The user interface for the application 620
The event handlers for the form 622
A data access class that reads and writes binary data 624
How to use FILESTREAM storage 632
How to enable FILESTREAM storage on the server 632
How to create a database with FILESTREAM storage 634
How to create a table with a FILESTREAM column 636
How to insert, update, and delete FILESTREAM data 636
How to retrieve FILESTREAM data 636
A data access class that uses FILESTREAM storage 638
t


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2008

Learn more about this book

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.