CODEWITHSUNDEEP
sqlsql-servert-sqlsql-server-2008
Cyber Slueth Omega
Cyber Slueth Omega

Reputation: 399

Sql 2008 code to open file

What is the SQL 2008 code to open a file, append some new lines, and save the file. Is there a way to do this all inside a stored procedure? Also, is there a way to automatically retrieve the script to do this from a "Tasks"->"Generate Scripts" menu options, or at least get close.

Upvotes: 2

Views: 2293

Answers (1)

Yves M.
Yves M.

Reputation: 3318

You can do it with plain T-SQL...

http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/

to make it work, click on those links in the text as well...

http://www.simple-talk.com/code/WorkingWithFiles/uftReadFileAsTable.txt

http://www.simple-talk.com/code/WorkingWithFiles/spWriteStringTofile.txt

Or you might write a function in c#...

http://blog.adampresley.com/2009/writing-csharp-functions-for-sql-server-and-clr-integration/

Upvotes: 3

Related Questions