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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 data type

Author  Topic 

kiranmurali
Yak Posting Veteran

55 Posts

Posted - 2010-10-27 : 03:31:08
Hi,

I ahve to attach a word file in my data base.

for example i have to attach a Resume.

i wanted to know what is the data type and and how to upload the file in to the table.

Thanks in Advance
Kiranmurali

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-10-27 : 03:54:43
Possible methods

1 Save file in server's directory and store file path in a column
2 Save entire file in a column using nvarchar datatype

Madhivanan

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

Sachin.Nand

2937 Posts

Posted - 2010-10-30 : 13:11:41
OR

use filestream object as you seem to be using SQL 2008

PBUH

Go to Top of Page
   

- Advertisement -