"Chandra" wrote:

> How to send the table data into a flat file (*.txt or *.sql)?
>
> I tried with BCP but unable to locate the file..where it will be created??

"Chandra" wrote:

> Hi Chandra
>
> The file will be created in the 'Server' and directory that u specefied.
>
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://www.SQLResource.com/
> ---------------------------------------
>
>
>
> "Chandra" wrote:
>
> > How to send the table data into a flat file (*.txt or *.sql)?
> >
> > I tried with BCP but unable to locate the file..where it will be created??

"Chandra" wrote:

> Hi Chandra,
>
> Thanks for the reply.
>
> do u have any idea on getdirectory function of oracle..what is the
> equivalent in Sql server??
>
> TIA
>
>
> "Chandra" wrote:
>
> > Hi Chandra
> >
> > The file will be created in the 'Server' and directory that u specefied.
> >
> >
> > --
> > best Regards,
> > Chandra
> > http://chanduas.blogspot.com/
> > http://www.SQLResource.com/
> > ---------------------------------------
> >
> >
> >
> > "Chandra" wrote:
> >
> > > How to send the table data into a flat file (*.txt or *.sql)?
> > >
> > > I tried with BCP but unable to locate the file..where it will be created??

"Chandra" wrote:

> hi
>
> you can run all the DOS commands from SQL Query Analyser using xp_cmdshell
>
> eg:
> xp_cmdshell 'dir /ad'
> gives the list of directories.
>
> I am not sure if there is anything like getdirectory in Oracle. it might be
> an user defined function
>
> thanks and regards
> Chandra
>
>
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://www.SQLResource.com/
> ---------------------------------------
>
>
>
> "Chandra" wrote:
>
> > Hi Chandra,
> >
> > Thanks for the reply.
> >
> > do u have any idea on getdirectory function of oracle..what is the
> > equivalent in Sql server??
> >
> > TIA
> >
> >
> > "Chandra" wrote:
> >
> > > Hi Chandra
> > >
> > > The file will be created in the 'Server' and directory that u specefied.
> > >
> > >
> > > --
> > > best Regards,
> > > Chandra
> > > http://chanduas.blogspot.com/
> > > http://www.SQLResource.com/
> > > ---------------------------------------
> > >
> > >
> > >
> > > "Chandra" wrote:
> > >
> > > > How to send the table data into a flat file (*.txt or *.sql)?
> > > >
> > > > I tried with BCP but unable to locate the file..where it will be created??