Home » RDBMS Server » Server Administration » Urgent! Select to file
Urgent! Select to file [message #373012] Thu, 22 March 2001 08:41 Go to next message
Laert
Messages: 20
Registered: January 2000
Junior Member
Hi,

Can someone help me.
Is there any way to put into some file result of select from some stored procedure.

Thanx in advance
Laert

Report message to a moderator

Re: Urgent! Select to file [message #373014 is a reply to message #373012] Thu, 22 March 2001 11:37 Go to previous messageGo to next message
aish
Messages: 44
Registered: March 2001
Member
Try using SPOOL C:dir\filname.TXT in the procedure

Report message to a moderator

Re: Urgent! Select to file [message #373057 is a reply to message #373012] Sat, 24 March 2001 04:41 Go to previous message
Arjun V
Messages: 14
Registered: March 2001
Junior Member
Write a report to retirve the select statement and get it spooled into .doc file!!
sorry no trigger usage there.

-Arjun

Report message to a moderator

Previous Topic: Re: Urgent! Select to file
Next Topic: Re: Setting the SQL Prompt to show up the host name
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 07:03:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.