How can extract SQL Server Fulltext to a text file

I have basic SQL knowledge and wondering if it is possible to run a command or some type of script that will iterate through a query result and for each record, extract the fulltext data and save it to a text file on my local drive?

Thank you!

Answers


You may use bcp utility :

DECLARE @SQL VARCHAR(1000)

-- EXPORT ITEMS

SET @SQL = ' BCP dbo.ITEMS out '
SET @SQL = @SQL + 'C:\FOLDER\ITEMS.CSV -T -t; -c -C UTF-8 -S'
EXEC xp_cmdshell @SQL

Need Your Help

Precision of cos(atan2(y,x)) versus using complex <double>, C++

c++ performance numbers complex-numbers atan2

I'm writing some coordinate transformations (more specifically the Joukoswky Transform, Wikipedia Joukowsky Transform), and I'm interested in performance, but of course precision. I'm trying to do ...