Comments for SQLpathy https://sqlpathy.wordpress.com Share...Learn...Grow !!! Tue, 19 Nov 2019 13:16:56 +0000 hourly 1 http://wordpress.com/ Comment on How to use insert query to store images by Ravi https://sqlpathy.wordpress.com/2013/12/18/how-to-use-insert-query-to-store-images/comment-page-1/#comment-3458 Tue, 19 Nov 2019 13:16:56 +0000 http://sqlpathy.com/?p=296#comment-3458 Hi,
I followed above steps but getting following error. Could you please help on this.

INSERT INTO emp_photos(id,emp_image)
Values (2,(SELECT * FROM OPENROWSET(BULK N’C:\Users\ravinder.battula\Documents\Accenture\Projects\Petronas\Ravi\photos\photo01.jpeg’, SINGLE_BLOB) AS emp_image))

id int,
emp_image VARBINARY(MAX)

Error;
Msg 4861, Level 16, State 1, Line 7
Cannot bulk load because the file “C:\Users\ravinder.battula\Documents\Accenture\Projects\Petronas\Ravi\photos\photo01.jpeg” could not be opened. Operating system error code (null).

Thanks,
Ravi

Like

]]> Comment on LIST Partitioning in SQL Server by Kannan Chandrasekaran https://sqlpathy.wordpress.com/2012/08/09/list-partitioning-in-sql-server/comment-page-1/#comment-3255 Mon, 29 Jul 2019 06:34:10 +0000 http://sqlpathy.wordpress.com/?p=86#comment-3255 This works to some extent but not for all the scenarios. partition with state and the state with year wise data. In that case List and range will come into picture and will become composite partition. SQL server will not support composite partition only evolved database like oracle can support such scenarios. Better to use oracle instead of using SQL server.

Like

]]> Comment on How to use insert query to store images by sqlpathy https://sqlpathy.wordpress.com/2013/12/18/how-to-use-insert-query-to-store-images/comment-page-1/#comment-3202 Tue, 02 Jul 2019 19:09:37 +0000 http://sqlpathy.com/?p=296#comment-3202 In reply to Nadeem Khan.

Hi Nadeem,
This code is tested and used by many fellow community members. If you have made changes, can you please paste the sample code, I will check and get back to you. Thanks!

Like

]]> Comment on How to use insert query to store images by Nadeem Khan https://sqlpathy.wordpress.com/2013/12/18/how-to-use-insert-query-to-store-images/comment-page-1/#comment-3199 Tue, 02 Jul 2019 05:53:47 +0000 http://sqlpathy.com/?p=296#comment-3199 I had problem regarding these code
‘right paranthese missing;

Like

]]> Comment on How to use insert query to store images by sqlpathy https://sqlpathy.wordpress.com/2013/12/18/how-to-use-insert-query-to-store-images/comment-page-1/#comment-2680 Wed, 21 Nov 2018 01:18:13 +0000 http://sqlpathy.com/?p=296#comment-2680 In reply to Sagar.

I see. Please check if your database user has access to the location where image is stored.

Like

]]> Comment on How to use insert query to store images by Sagar https://sqlpathy.wordpress.com/2013/12/18/how-to-use-insert-query-to-store-images/comment-page-1/#comment-2678 Tue, 20 Nov 2018 09:23:59 +0000 http://sqlpathy.com/?p=296#comment-2678 In reply to sqlpathy.

I shift that image to database server. Till I have facing same error. Please help.

Like

]]> Comment on How to use insert query to store images by sqlpathy https://sqlpathy.wordpress.com/2013/12/18/how-to-use-insert-query-to-store-images/comment-page-1/#comment-2674 Wed, 14 Nov 2018 15:06:24 +0000 http://sqlpathy.com/?p=296#comment-2674 In reply to Sagar.

It seems that you are trying to insert image from local machine onto remote instance of sql server. Make sure that “image1.png” exists on the SQL Server machine.

Hope this helps!

Like

]]> Comment on How to use insert query to store images by Sagar https://sqlpathy.wordpress.com/2013/12/18/how-to-use-insert-query-to-store-images/comment-page-1/#comment-2673 Wed, 14 Nov 2018 07:01:09 +0000 http://sqlpathy.com/?p=296#comment-2673 Hi, the code you given is not working for me. please look into matter

Code :

Msg 4860, Level 16, State 1, Line 1
Cannot bulk load. The file “C:\User\Comp1\Image1.png” does not exist.

Like

]]> Comment on Replacing a Legacy System: Part-2 by Replacing a Legacy System: Part-1 – SQLpathy https://sqlpathy.wordpress.com/2018/10/06/replacing-a-legacy-system-part-2/comment-page-1/#comment-2547 Sat, 06 Oct 2018 00:37:55 +0000 http://sqlpathy.com/?p=444#comment-2547 […] that you understand WHY legacy applications should be replaced; In my next blog, I shall try to list down important technical challenges that we overcome for smooth […]

Like

]]> Comment on Replacing a Legacy System: Part-1 by Replacing a Legacy System: Part-2 – SQLpathy https://sqlpathy.wordpress.com/2018/09/19/replacing-a-legacy-system-part-1/comment-page-1/#comment-2546 Sat, 06 Oct 2018 00:36:41 +0000 http://sqlpathy.com/?p=442#comment-2546 […] my last post we focused on “WHY” we should replace a Legacy system. In this post we shall try to […]

Like

]]>