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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Storing Word docs in sql server

Author  Topic 

svicky9
Posting Yak Master

232 Posts

Posted - 2006-04-22 : 15:29:51
Hi Guys

i have a list of 10 word docs and i want to store them in sql server.
How can i do that??

Should i create any fmt files for that???

Thanks
Vic

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-04-22 : 15:56:55
it's not best practice to store files in SQL server.
it's better to store files on the disk and only the path to them in the server.

but if you must you can use image column.
it stores a byte array of anything you want.

Go with the flow & have fun! Else fight the flow
Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"]
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-04-22 : 16:15:46
Read the articles on storing images in SQL server in the FAQ Section
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-24 : 01:31:45
Also refer
http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.mspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -