ALTER DATABASE Masi2Dev
          ADD FILEGROUP FileStreamGroup CONTAINS FILESTREAM;
ALTER DATABASE Masi2Dev
          ADD FILE
                   (NAME = FileStreamData ,FILENAME = 'C:\MSSQL\Data'
          ) TO FILEGROUP FileStreamGroup;

USE TEST_DB
 GO
 CREATE TABLE FILETABLE
 (
 ID     INT IDENTITY,
 GUID    UNIQUEIDENTIFIER ROWGUIDCOL NOTNULL UNIQUE,
 DATA     VARBINARY(MAX) FILESTREAM
 );



select * from filestreamdatastorage


Use FileStreamDB
GO
INSERT INTO [FileStreamDataStorage] (FileStreamData) 
SELECT * FROM OPENROWSET(BULK N'D:\WorkSpace\Breslyn.jpg', SINGLE_BLOB) AS Document
GO 

uspFileStreamIns 




USE FileStreamDB
GO
SELECT ID, FileStreamData
, FileStreamDataGUID
, [DateTime]
FROM [FileStreamDataStorage]
GO

--Get Path name
DECLARE @filePath varchar(max)
SELECT @filePath = FileStreamData.PathName()
FROM FileStreamDataStorage
WHERE ID = 3
PRINT @filepath

--Get Transaction Context
DECLARE @txContext varbinary(max)
BEGIN TRANSACTION
SELECT @txContext = GET_FILESTREAM_TRANSACTION_CONTEXT()
PRINT @txContext
COMMIT