worddocument in to sqlserver | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

worddocument in to sqlserver

Hi All,
Can u pls explain me to how to store the word document into sqlserver? i.e user can able to download the word document from sqlserver and can edit and again able to upload the document into sqlserver. Thank is Advance. Jai
You would need to store it in the image/Varbinary datatype. Take a look at Books Online you’ll
see some examples. http://www.sql-server-performance.com/forum/post.asp?method=TopicQuote&TOPIC_ID=11766&FORUM_ID=14 Importing Word Documents into SQL Server
http://www.sqlmag.com/Article/ArticleID/37903/sql_server_37903.html
MohammedU.
Moderator
SQL-Server-Performance.com
Hi,
It is not recomended to store documents directly in SQL Server, Refer suggested Thread. Here is a link of a wonder full article on "BLOB or NOT to BLOB" onhttp://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45 Regards Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
Jey
What is the database size and also the expected growth? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>