Storing Images and BLOB files in SQL Server

CREATE TABLE BLOBTest
(
TestID int IDENTITY(1,1),
BLOBName varChar(50),
BLOBData varBinary(MAX)
);

INSERT INTO BLOBTest
	(BLOBName, BLOBData)
	SELECT 'First test file', 
		BulkColumn FROM OPENROWSET(
			Bulk 'C:\temp\nextup.jpg', SINGLE_BLOB) AS BLOB

Storing Images and BLOB files in SQL Server (databasejournal.com)
Part 2

This entry was posted in SQL Server 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s