バイナリデータのInsert

MSSQL


テーブル例

CREATE TABLE [dbo].[tblHoge](
	[ID] [int] NOT NULL,
	[excel_data] [varbinary](max) NOT NULL,
 CONSTRAINT [PK_tblHoge] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


Insert例

INSERT INTO tblHoge([id],[excel_data]) 
SELECT 
	1,
	BulkColumn as [excel_data]
FROM 
	OPENROWSET(BULK N'c:\exceltest.xlsx', SINGLE_BLOB) as excel_data

※BulkColumnはOPENROWSETで取得した値を示す


動作確認環境:SqlServer2014 Express