MCTS 70-433 Storing Binary Objects / Files in SQL Server

To store FILESTREAM data (image or text files) you need to use the varbinary(max) datatype:

Create table photos(

photoID int NOT NULL IDENTITY(1,1),

photo varbinary(max) FILESTREAM NULL);