Insert Picture into SQL Server 2005 Image Field using only SQL

by 
CREATE TABLE Employees
(
    Id int,
    Name varchar(50) not null,
    Photo varbinary(max) not null
)


INSERT INTO Employees (Id, Name, Photo) 
SELECT 10, 'John', BulkColumn 
FROM Openrowset( Bulk 'C:\photo.bmp', Single_Blob) as EmployeePicture

More Related Contents:

  1. Insert results of a stored procedure into a temporary table
  2. Select top 10 records for each category
  3. How important is the order of columns in indexes?
  4. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  5. sql query to return differences between two tables
  6. SQL Server – transactions roll back on error?
  7. Difference between a User and a Login in SQL Server
  8. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  9. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  10. How to insert multiple records and get the identity value?
  11. How do I group on continuous ranges
  12. How can a LEFT OUTER JOIN return more records than exist in the left table?
  13. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  14. Dynamic SQL to generate column names?
  15. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  16. SQL comma-separated row with Group By clause
  17. Column name or number of supplied values does not match table definition
  18. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  19. SQL Server PIVOT perhaps?
  20. How to find consecutive rows based on the value of a column?
  21. How to escape square brackets inside square brackets for field name
  22. How do you copy a record in a SQL table but swap out the unique id of the new row?
  23. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  24. How do I find the data directory for a SQL Server instance?
  25. Add a row number to result set of a SQL query
  26. Compare dates in T-SQL, ignoring the time part
  27. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. Backup SQL Schema Only?
  30. Hierarchical Queries in SQL Server 2005

Leave a Comment