I'd like know how can we create an output file to receive the result of one STORE PROCEDURE like that
CREATE PROCEDURE myproc
@test int OUTPUT
SELECT * FROM Journal
That means the data from the query SELECT * FROM Journal
has been to created in one file.