How to store image file in Sql server database?
Answer Posted / guest
Yes, you can store image files in SQL Server. In fact, SQL
Server has a datatype called image for exactly this
purpose. It will store any binary data up to 2 GB in size.
There are many ways to get image files into your image
column. Among the easiest is the Textcopy utility located
in the Program FilesMicrosoft SQL ServerMSSQLBinn
directory. Use the command "textcopy /?" to get the command
line syntax for this utility.
Another way to get image files in and out of SQL Server is
to write your own program using ADO or ADO.Net, or create
an ActiveX dll that can be called by SQL Server's sp_OA*
extended stored procedures.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Is string a class in c#?
What is difference between int and int in c#?
How to find out that the code is written as managed or un-managed code?
write a program to find the biggest palindrome in the given string
Is as keyword in c#?
Is a c# interface the same as a c++ abstract class?
What is a static class in c#?
What is whitespace in c#?
Where is the main method in c#?
Explain static class members.
What is difference between a constant and read-only in C#?
Can constructor be protected in c#?
What is the use of generics in c#?
Is c# still popular?
What is attribute c#?