What T-SQL Command can I use?

#1

I obtained a return value from a store procedure.
What T-SQL command can help me to write this return value
into a .txt file on hard drive?
Thanks for help.

-Tom

#2

Hi,

Execute the stored procedure from command prompt,

osql -U user -P password -S Servername -d databse name -Q "Procedure name
wirh parameters" -o "c:\sp_result.txt" -n

This command will redirect the output of procedure to sp_result.txt in c
drive of SQL Server.

Thanks
Hari
MCDBA

"Tom Torain" <TST_MC (AT) hotmail (DOT) com> wrote

Quote:

I obtained a return value from a store procedure.
What T-SQL command can help me to write this return value
into a .txt file on hard drive?
Thanks for help.

-Tom

#3

You may want to use isql vs osql. osql has the added overhead of using ODBC.
"Hari" <hari_prasad_k (AT) hotmail (DOT) com> wrote

Quote:

Hi,

Execute the stored procedure from command prompt,

osql -U user -P password -S Servername -d databse name -Q "Procedure name
wirh parameters" -o "c:\sp_result.txt" -n

This command will redirect the output of procedure to sp_result.txt in c
drive of SQL Server.

Thanks
Hari
MCDBA

"Tom Torain" <TST_MC (AT) hotmail (DOT) com> wrote in message
news:c1e101c3ee70$c4247fa0$a101280a (AT) phx (DOT) gbl...
I obtained a return value from a store procedure.
What T-SQL command can help me to write this return value
into a .txt file on hard drive?
Thanks for help.

-Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What T-SQL Command can I use?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

What T-SQL Command can I use? - 02-08-2004 , 12:24 PM

Re: What T-SQL Command can I use? - 02-08-2004 , 12:31 PM

Re: What T-SQL Command can I use? - 02-10-2004 , 02:46 PM