SQL Server Indonesia User Groups Community Insert Image into Database Table - Rachmat Hariyanto
Welcome to SQL Server User Group Indonesia
Sign in JoinHelp | Sign In Live ID

Rachmat Hariyanto

There's always time for coding! My friends are Visual Studio 2008 Team System (ASP .NET 3.5, LINQ, VB .NET), jQuery, CodeSmith and SQL Server 2005/2008.

Insert Image into Database Table

Berikut ini adalah script SQL yang dapat digunakan untuk memasukkan suatu file image (misalkan myImage.jpg) ke dalam sebuah tabel dalam suatu database SQL Server 2005.

CREATE TABLE myTable(Document varbinary(max))

GO

INSERT INTO myTable(Document)

SELECT * FROM

OPENROWSET(BULK N'D:myImage.JPG', SINGLE_BLOB)

AS Document

 

Semoga bermanfaat!

Published Tuesday, February 24, 2009 3:01 AM by Rachmat Hariyanto

Comments

No Comments