How to store image in SQL Server database tables column [duplicate]

by

give this a try,

insert into tableName (ImageColumn) 
SELECT BulkColumn 
FROM Openrowset( Bulk 'image..Path..here', Single_Blob) as img

INSERTING

enter image description here

REFRESHING THE TABLE

enter image description here

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. SQL Server dynamic PIVOT query?
  3. SQL Server – Best way to get identity of inserted row?
  4. Should I use != or for not equal in T-SQL?
  5. How to update two tables in one statement in SQL Server 2005?
  6. SQL Server Process Queue Race Condition
  7. Create a date from day month and year with T-SQL
  8. How should I pass a table name into a stored proc?
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. SQL – Subtracting a depleting value from rows
  11. Parse comma-separated string to make IN List of strings in the Where clause
  12. How to set variable from a SQL query?
  13. SELECT FOR UPDATE with SQL Server
  14. Compare DATETIME and DATE ignoring time portion
  15. How to group by month from Date field using sql
  16. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  17. SQL dot notation
  18. Split function in SQL Server 2008
  19. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  20. Can I set ignore_dup_key on for a primary key?
  21. Unordered results in SQL
  22. Using PIVOT in SQL Server 2008
  23. How to find column names for all tables in all databases in SQL Server
  24. SQL Row_Number() function in Where Clause
  25. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  26. How do I compare 2 rows from the same table (SQL Server)?
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Group consecutive rows of same value using time spans
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment