Inserting an Image into a Column

Downloads
22973.zip

How do I use a SQL INSERT query to insert an image into a column that has an image data type?

Listing 1 shows sample Microsoft Visual Basic (VB) code for inserting the image.

Discuss this Article 1

tirumala (not verified)
on Jun 2, 2004
hey don't u people have new stuff . all these things are already in sql help . i want to know how will u save a picture file like abc.bmp,xyz.gif into image column of sql server. u people r just takeing saved picture from the sql server and again saving the same thing. its meaning less. i am sorry if i hurt

Please or Register to post comments.

IT/Dev Connections

Las Vegas
September 30th - October 4th

Paul ThurottOur Experts will show you:
• Common SQL Server
Problems
• Best Practices for T-SQL
• SQL Server Integration
Services
• Database Development

Come See Michael Otey & Tim Ford in Person!

Early Registration Now Open

From the Blogs
May 21, 2013
blog

A Common Misconception about MAXDOP

Out of the box, SQL Server is (and has been) able to take advantage of multiple processors/cores without any effort on behalf of administrators....More
May 9, 2013
blog

My ISO 8601-Compliant Signature 2

My family recently just "officially" announced that we're in the process of adopting a child from South Africa. We're quite excited, of course, but there's a ton of paperwork to do—along with the need for gobs of signatures....More
May 8, 2013
blog

Use SSIS for ETL from Hadoop

In this blog post, Mark Kromer walks you through using SSIS as a way to use ETL techniques using Microsoft's Hadoop on Windows (HDInsight) as a source using Hive connectors...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.