15 SSRS - Images from Database and External Sources (SQL Server Reporting Services)
In this video, we will learn about how to display images from database and external sources (SQL Server Reporting Services)
Related SQL Scripts:
--Creating Sample Table
CREATE TABLE dbo.[SampleImages]
(
[ID] INT IDENTITY(1,1) PRIMARY KEY,
[NAME] VARCHAR(50),
[Photo] VARBINARY(MAX)
)
--Inserting Sample Data
INSERT INTO dbo.[SampleImages]
VALUES
(
'Satyarth Programming Hub New',
(SELECT * FROM OPENROWSET(BULK N'D:\Downloads\Documents\Me1.jpeg', SINGLE_BLOB) as T1)
)
--Selecting Data from table
SELECT * FROM dbo.[SampleImages]