I have a table in sql server with the following structure
CREATE TABLE [dbo].[PHOTO] (
[PHOTOID] int IDENTITY(1, 1) NOT NULL,
[PRODUCTID] nvarchar(255) NOT NULL,
[COMMENTS] nvarchar(2000) NOT NULL,
[PHOTOBASE64] varbinary(MAX) NULL,
[DATECREATED] datetime NULL)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
WITH (DATA_COMPRESSION = NONE);
I want to extract the data into excel.
Has anyone a working example?