CODEWITHSUNDEEP
c#sql-server-2005
salman
salman

Reputation: 565

SQL Server 2005 inserting image

I am using SQL Server 2005 connected with C# winforms app. I added new field of type image, then I inserted the data manually from show table data option, can someone tell me how to insert the image manually? And which type is the best for image? thanks

Upvotes: 0

Views: 425

Answers (2)

marc_s
marc_s

Reputation: 755321

The data type IMAGE is deprecated as of SQL Server 2005 - you should use VARBINARY(MAX) instead, which also support up to 2 GB in size.

Upvotes: 1

Pankaj Agarwal
Pankaj Agarwal

Reputation: 11309

in DB image save in binary format.

Upvotes: 0

Related Questions