Storing text files in SQL Server 2005 Database

This is a discussion on Storing text files in SQL Server 2005 Database within the sqlserver-datawarehouse forums in Data Warehousing category; I need to store our ASP files into a SQL 2005 database. Average file size is about 35 KB. Could someone please explain an easy way to store text files in SQL 2005? Thank you....

Go Back   Database Forum > Data Warehousing > sqlserver-datawarehouse

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 07-09-2008, 01:58 PM
Default Storing text files in SQL Server 2005 Database

I need to store our ASP files into a SQL 2005 database. Average file size is
about 35 KB. Could someone please explain an easy way to store text files in
SQL 2005?

Thank you.
Reply With Quote
  #2  
Old 07-10-2008, 12:24 PM
Default Re: Storing text files in SQL Server 2005 Database

Interesting notion - to use a datawarehouse to store your ASP files...

"Nam" wrote in message
news:0D574706-A2A6-4A7E-956F-D2AB954BB31A-at-microsoft.com...
>I need to store our ASP files into a SQL 2005 database. Average file size
>is
> about 35 KB. Could someone please explain an easy way to store text files
> in
> SQL 2005?
>
> Thank you.



Reply With Quote
  #3  
Old 07-10-2008, 09:33 PM
Default Re: Storing text files in SQL Server 2005 Database

take a look at the binary data type.
you can found samples on the web to learn how to store / retrieve files in
SQL Server


"Nam" wrote in message
news:0D574706-A2A6-4A7E-956F-D2AB954BB31A-at-microsoft.com...
> I need to store our ASP files into a SQL 2005 database. Average file size
> is
> about 35 KB. Could someone please explain an easy way to store text files
> in
> SQL 2005?
>
> Thank you.


Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:16 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.