Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Oliver wang
Yak Posting Veteran
50 Posts |
 Posted - 2012-05-21 : 05:55:37
|
| Hi everyone,Does anybody know how to store a picture or a file(say, word file) into a table. Let's suppose the file is located in c:\, and is there anyway to transfer it into varBinary and then store? Thanks for your help.regards,Oliver |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-21 : 16:42:48
|
| use varbinary(max) for datatype. but why do want to store it in database itself?Also have a look at FILESTREAM option------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Oliver wang
Yak Posting Veteran
50 Posts |
Posted - 2012-05-21 : 22:15:13
|
| Thank you for your reply, visakh. Actually I'm doing a test about full text index. Yes, the datatype is Varbinary(max), but I want to know whether we can use T-SQL scripts to insert word documents into a table. Then I can do a full text search with a key word for the document that I'm interested in. Could you please give more advice? Thanks a lot.regards,Oliver |
|
|
|
|
|
|
store files or pictures in a table