Execute the following SQL Server T-SQL script in SSMS Query Editor to retrieve a product photo using varbinary(max) column type:

USE AdventureWorks2008;

GO

CREATE FUNCTION Production.fnProductPhoto

               (@ProductID INT)

RETURNS VARBINARY(MAX)

AS

  BEGIN

    DECLARE  @Photo VARBINARY(MAX)

    SELECT @Photo = pp.LargePhoto

    FROM   Production.ProductPhoto AS pp

           INNER JOIN Production.ProductProductPhoto ppp

             ON pp.ProductPhotoID = ppp.ProductPhotoID

    WHERE  ppp.ProductID = @ProductID

    RETURN @Photo

  END

GO

SELECT Production.fnProductPhoto(1)

GO

/*

0x474946383961F0009500F7000000000080000000800080 .....

*/