Around and About .NET World

Il blog di Marco Minerva
posts - 1671, comments - 2232, trackbacks - 2135

My Links


Contattami su Live Messenger:

MCTS: Windows, Web, Distributed Applications & SQL Server

MCPD: Enterprise Applications

Tag Cloud


Post Categories


Inserire dati nei campi VarBinary e Image da query SQL

Usando la funzione OPENROWSET è possibile inserire dati binari nei campi VarBinary o Image di un database di SQL Server usando una semplice query T-SQL:

INSERT INTO Files (Name, Content)
SELECT 'Prova.bmp', BulkColumn FROM OPENROWSET(BULK 'c:\noimage.bmp', SINGLE_BLOB) AS ImageLoad

Fonte: SQL Kit - Tips and Scripts for T-SQL, BI

Technorati Tag:

Print | posted on venerdì 10 luglio 2009 18:10 | Filed Under [ SQL Server ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET