am using sql server 2008 R2..
i need to insert an image through sql cmd ?
my table structure is
SELECT TOP 1000 [AddressID]
[Image]
FROM [xxx].[dbo].[tblAddress]
how can i insert an image where AddressID='1' ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Munesh SharmaPosted Sep 10, 2015, 6:10 AM
Raja TPosted Sep 10, 2015, 5:46 AM
Raja TPosted Sep 10, 2015, 5:40 AM
Rajeesh MenothPosted Sep 10, 2015, 5:34 AM
Ruga LincyPosted Sep 10, 2015, 5:33 AM
Ruga LincyPosted Sep 10, 2015, 5:31 AM
Ruga LincyPosted Sep 10, 2015, 5:30 AM
Joginder BangerPosted Sep 10, 2015, 5:23 AM
Raja TPosted Sep 10, 2015, 5:20 AM
Joginder BangerPosted Sep 10, 2015, 5:10 AM
Joginder BangerPosted Sep 10, 2015, 5:08 AM
Raja TPosted Sep 10, 2015, 5:05 AM
/* Insert a new category with an image */
INSERT INTO Categories(CategoryName, CategoryPicture)
Values ('Another Category', (SELECT * FROM OPENROWSET(BULKN'C:\Temp\AnotherCategory.jpg', SINGLE_BLOB) AS CategoryImage))
Ruga LincyPosted Sep 10, 2015, 5:04 AM
Upendra Pratap ShahiPosted Sep 10, 2015, 5:01 AM