Can I write and read from text file in stored procedure

[go2bharat]

I an new to SQL server and was wondering if it is possible for me to run queries in a SP and write the result set to a file (lets say ASCII file). Later, can I read data from this ascii file in the SP and then lets say use it to insert values in some tables? Is it possible to do this?

 

[dev2005]

Put the information you want into a global temporary table and then bcp it out to a file via xp_cmdshell.

xp_cmdshell "bcp <dbname>..<tablename> out c:\yourfile.txt -Usa -P<password> -c