I checked and found command should be '-c -T -t "|" '

eg.,

'BCP ' + @TABLE + ' QUERYOUT ' + @DIR + @FILE + '-c -T -t "|"...

I tried initially and now but the result is same (-t| -r\r)

"The system cannot find the path specified"

I am exporting records by using Stored procedure. The master table contains many coulmns, I needed to export all master table columns (10 columns) into .dat file,

eg of...

Lately I found CHAR(124) will be the Pipe Symbol (|)

Thanks for your timings...:D

SELECT CONVERT(VARCHAR,GetDate(),112) 😛

Try to ping the URL / IP address which you have entered into TNSNames.ORA and check the PORT and connect data have entered correctly. If it gives response check...

Thanks very much...is it not required to restore tempdb database?

Rajan, This is one of the interview questions which I faced. I searched but no luck. Is there any way to add?

Renuka, Thanks for the information. Is there any other way to check like show / update statistics method to check the query execution?

Thanks in advance.

Hi, you can do the following to export data from table to file

DECLARE @sql VARCHAR(2000)

DECLARE @DAY VARCHAR(20)

DECLARE @FILE VARCHAR(100)

DECLARE @DIR VARCHAR(100)

DECLARE @TABLE VARCHAR(100)

SET @DIR = 'G:\DRIVE\'

SET @TABLE = '"SELECT...