Insert images with TSQL query from filesystem to a Microsoft SQL Server 2008 database

August 3, 2009 Roel van Lisdonk 0 Comments

To insert a image from filesystem to a Microsoft SQL Server 2008 database with a TSQL query, use: 

INSERT INTO MyTable(MyImageColumn)
SELECT * FROM
OPENROWSET(BULK N'C:\Image1.jpg', SINGLE_BLOB)

Tags: ,

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Tags

Angular (16) AngularJS (28) ASP .NET (66) C# (191) Chrome (7) CSS (27) Entity Framework (17) Excel (9) HTML (8) IIS (29) Integration Services (18) Internet Explorer (11) Javascript (70) jQuery (7) Kendo (6) Kendo UI (16) LINQ (10) LLBLGen (13) MVC (7) NAnt (9) Outlook (19) Outsystems (6) PowerPivot (9) PowerShell (31) Reporting Services (21) Setup Packages (14) SharePoint (28) Silverlight (15) SQL Server (88) SSIS (17) T-SQL (44) Telerik (12) TFS (11) TypeScript (13) Unit tests (15) Visual Studio (101) Visual Studio Code (8) VMWare (10) WCF (12) WCF RIA Services (7) Windows (11) Windows 7 (34) Windows 8 (12) WPF (8) XML - XSLT - XPath (8)

Archive