Questions tagged [varbinary]

Is there any way to upload a file to a varbinary on SQL Server without writting a program to do it?

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 'C:\file.bin', SINGLE_BLOB) AS File GO but I'm…

I have 2 server : Database Server Application Server and client pc. On Database server using ms sql server i save data file in varbinary(max). On Application server using c# linq to sql i query select top 1 file from database server. It takes too…