Tejas

• Jun 12th, 2006

 

spool c:<your text file name with path>

@<your SQL file name with absolute path which contains the query>

spool off

vssandilya

 Profile Answers by vssandilya Questions by vssandilya

• Jun 12th, 2006

 

please give an exampe as to how to do it in SQL SERVER

FOR EXAMPLE IAM HAVING A TABLE DEPARTMENT1

I WANT TO STORE THE CONTENTS OF

SELECT * FROM DEPARTMENT1 INTO  C:KK.TXT.

Sarfaraz Ahmad Khan

• Jul 18th, 2006

 

yeah its very simple

use the syntax like this:

spool <somefilename>  (you can give the path also like c:sarfarazxyz.txt)

<now your query>

and to see that whether the result is actually stored in the file or not go to the file menu>open and select the name of your file you will get your result.

Note that when you noyt give the extension then the default file extension will be .lst