Some kinds of data have special formats, are very large, or vary greatly in size. Here, I’ll show you techniques for working with text and binary data. In this chapter, I’ll cover the following:
- Understanding SQL Server text and binary data types
- Storing images in a database
- Retrieving images from a database
- Working with text data
I’ll also present the T-SQL for creating tables in the
tempdb database, which is intended to hold any temporary table. I’ll start by covering what data types support these kinds of data.
SQL Server provides the types
VARBINARY for working with reasonably small text ...