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 the advantage of dependency injection?

726


Why is .net so popular?

700


What is hash c#?

676


Why var is used in c#?

718


How do I run managed code in a process?

725


Why do we need abstraction in c#?

673


Which is faster list or dictionary in c#?

743


Why do we use polymorphism in c#?

663


What is xpath in c#?

647


Are string objects mutable or immutable?

707


What is literal in c#?

657


What is delegates in c#?

681


What are predicates in c#?

728


What is parameters in c#?

702


What is lazy keyword in c#?

675