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


Please Help Members By Posting Answers For Below Questions

What is public or shared assemblies ?

787


Explain how to use an extender provider in the project.

729


Does c# support a variable number of arguments?

796


What is the correct way of declaring an xml namespace?

661


Is null in c#?

671


what is main function of alternate teamplate of datalist?

1943


What is type cast in C#?

780


What are the advantages of using c#?

732


What is the difference between as and is operators in c#?

697


What is an extension method in c#?

741


Can a class be protected in c#?

683


What is oledbconnection c#?

699


Can we create instance of private class in c#?

700


Enlist some of the properties of a thread class?

716


What is the difference between static class and singleton class in c#?

708