November 11, 2005 at 3:44 am
Hi ,
I want to store large files in a table.I am using SQLserver 2000
and working on vb.net . Should i pass file contents as input variables to the stored procedure or my stored procedure should
read the file content itself before inserting the data inside the table.
Files are both of type text as well XML.
Let me know which approach is more feasible and how do it.
Later i also need to read contents of the file from the table.
Regards,
Vikram
November 14, 2005 at 8:00 am
This was removed by the editor as SPAM
November 15, 2005 at 6:05 am
If you want to blindly load xml and text data you can use a text data type to store the data. You will be able to pass the data to a text data type as an input parameter to a stored procedure for insert and updates. You can select the data just like any other column. With a text data type you will not be able to create indexes on that column and the data may become very fragemnted and large.
Consider Full text indexing for documents and normalizing a relational structure fot the XML if feasible.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply