0
votes
3answers
1k views

OPENROWSET, binary files, varchars and varbinaries

I'm trying to upload a binary file into SQL Server, into a varbinary field. I've came up with this query to do it: INSERT INTO Files(File, Name) SELECT "file.bin" AS Name * FROM OPENROWSET(BULK ...