store a file into table from TSQL

Question

Possible Duplicate:
Files - in the database or not?

I Want to store a file into sql server 2008 from TSQL (Management Studio). I Know the file saving into varbinary column can be done by using the .NET

But I want to do this from Management Studio.

In C# and VB.NET we saving file into varbinary column by using ReadAllBytes()

How I can achieve this in Management Studio

score 0 · Accepted Answer · edited May 23 '17 at 12:40

0

Please read about File Stream too.

edited May 23 '17 at 12:40

Community

answered Jan 12 '13 at 06:25

MarkD

score 0 · Answer 2 · edited May 23 '17 at 12:40

Check my answer on this question

Guidelines for using filestream

UPDATE:

If you just need a solution to load a file in sql server and save it to a table, here're some approaches to achieve this

Here's a sample query

BULK
INSERT Test
FROM 'c:\test.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
SELECT *
FROM Test

Good Luck!

2 Answers2