How can I insert binary file data into a binary SQL field using a simple insert statement?

by

I believe this would be somewhere close.

INSERT INTO Files
(FileId, FileData)
SELECT 1, * FROM OPENROWSET(BULK N'C:\Image.jpg', SINGLE_BLOB) rs

Something to note, the above runs in SQL Server 2005 and SQL Server 2008 with the data type as varbinary(max). It was not tested with image as data type.

More Related Contents:

  1. Check if table exists in SQL Server
  2. How do I generate a random number for each row in a T-SQL select?
  3. Find index of last occurrence of a sub-string using T-SQL
  4. INSERT INTO @TABLE EXEC @query with SQL Server 2000
  5. Max Nbr of Months W/ No Activity in Past 12 Months
  6. SQL server query to output the data shown below
  7. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  8. Combine multiple results in a subquery into a single comma-separated value
  9. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  10. Floor a date in SQL server
  11. How to drop a table if it exists?
  12. Create a view with ORDER BY clause
  13. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  14. INSERT INTO vs SELECT INTO
  15. Possible to store value of one select column and use it for the next one?
  16. How FOR XML PATH(”) works when concatenating rows
  17. Scheduled run of stored procedure on SQL server
  18. SQL Server variable columns name?
  19. What is the Oracle equivalent of SQL Server’s IsNull() function?
  20. SQL Recursive CTE: Finding objects linked by property
  21. PRINT statement in T-SQL
  22. T-sql – determine if value is integer
  23. Convert decimal time to hours and minutes
  24. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  25. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  26. “If not exists” fails on SQL CE
  27. Does the `nodes()` method keep the document order?
  28. Find last sunday
  29. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment