Day 21. Handling BLOBs in T-SQL
As you have learned, Microsoft SQL Server 2000 supports many different data types that you can use to store data in the database. Most of these data types should have been familiar to you. Whether or not you have programmed before, integers, decimals, characters, and money are pretty standard types of data that you work with all the time. However, we have not really taken a look at one other group of data types that SQL Server 2000 supports. These are the large object data types or LOBs. In this lesson, we will take a look at the following:
How BLOBs are stored
Modifying BLOB data
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
