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 lazy class in c#?

469


What is satellite assembly? And steps to create satellite assembly?

512


Explain inheritance in c#?

540


How to use session under class file of APP_Code folder?

515


Why dictionary is used in c#?

542






What exactly is serverless?

422


Give examples for reference types?

536


What is parameter c#?

531


Are c# constructors the same as c++ constructors?

517


Define acid rule of thumb for transactions in c#.

479


Can a class have multiple constructors c#?

496


Why abstract class can not be instantiated?

448


Is namespace necessary in c#?

489


Can enum be null c#?

519


Differentiate between object pooling and connection pooling in c#?

539