Insert an image into a SQL table from SQL

I so love my job. Every day is something new.

Today I'm trying to display an image in a grid, and the control requires that the image be stored in SQL. It's a pain to write a .NET app do to that, so I researched to see if it's possible to do from SQL.

Below is a short piece of code that creates a SQL table and inserts an image from disk into it.


Calling a web service from SQL
Case sensitive SQL queries
Connection String Example
Copy ANY TABLE from one database to another
Create (and restore a database to) a TEST server for app testing
Creating a date calendar table
Find table and field a particular value reside
Find tables that have no permissions granted, and fix them
Get a person's age from their birthdate
Get the text of all the triggers in a database
Group by Grouping Sets example
How to format T-SQL
Insert an image into a SQL table from SQL
Log the user that changed a field
Loop through a string and show ASCII characters
Paging query contest
Parsing @tags from a SQL text field
Query that adds a blank like to the result set if the original resultset has more than one line
Remove unwanted characters from a field in SQL
sp_send_dbmail example
SQL code to resequence a grid
SQL Trigger Nest Level
Strip leading zeros
Suppress the results of a stored procedure
Table Value Constructors

... and you 'll find more on the SQL (General) Menu

CREATE TABLE Employees

(

Id int,

Name varchar(50) not null,

Photo varbinary(max) not null

)

INSERT INTO Employees (Id, Name, Photo)

SELECT 10, 'John', BulkColumn

FROM Openrowset( Bulk 'C:\photo.bmp', Single_Blob) as EmployeePicture

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

Insert an image into a SQL table from SQL

Related Articles

... and you 'll find more on the SQL (General) Menu