Around and About .NET World

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

My Links

News

Contattami su Live Messenger:


MCTS: Windows, Web, Distributed Applications & SQL Server

MCPD: Enterprise Applications

Tag Cloud

Archives

Post Categories

Links

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 Friday, July 10, 2009 3:10 PM | Filed Under [ SQL Server ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET