SQL Server filestream: how to read csv into table

336 Views Asked by At

I copied a .CSV file dataset_with_pred2.csv into the filestream folder in SQL Server. Is it possible to read it into table?

Now, everything I can do is to retrieve the .csv file into string via:

select cast(file_stream as varchar(max)) 
from [dbo].[MODEL_FILETABLE] with (READCOMMITTEDLOCK) 
where name = 'dataset_with_pred2.csv'

It returns comma separated values.

0

There are 0 best solutions below