Listing 2: Declaring and Using the FILESTREAM Data Type

USE MyFileStreamDB
CREATE TABLE dbo.MyFSTable
(
  FS_id UNIQUEIDENTIFIER ROWGUIDCOL
  NOT NULL UNIQUE,
  FSData VARBINARY(MAX) FILESTREAM
);

INSERT into dbo.MyFSTable
VALUES(newid(), CAST
  ('Store this as a stream'
  As VARBINARY(MAX)))