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
What is the usage of Enumeration in C# Programming and is it good to use or not ?
Can we maintain state in webservice?
What are the 2 types of data types available in c#?
What are c# collections?
How many types of serialization are there in c#?
What is regex c#?
How do I create a multi language, multi file assembly?
Why do we use methods in c#?
How can we set class to be inherited, but prevent the method from being over-ridden?
Can we override main method in c#?
What is the difference between method and constructor in c#?
What is event and delegates in c#?
When do you generally use a class over a struct?
What is a delegate? Explain.
How many constructor can a class have?