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
Why dictionary is used in c#?
What is the purpose of reserved word using in c#?
What is action c#?
write program in c# using this instructions name avinash varma ,work experiance<2,nochildren his work experiance is higher than 5 years,more than one children one children name is diwakar,number of years of work eperiance at current company is the ratio of children and work experiance is 0.21 to 0.5
How do you declare an arraylist?
What is difference between float and integer?
How do you use nullable?
Can extension methods access private members?
What is xml serializer?
What is remote data?
What is the difference between yield and return?
When should I throw an exception?
Why is .net so popular?
Are structs value types c#?
Does constructor return any value in c#?