Where the data stored if we use BCP commandHi There,
I have used bcp command to export data from sql server to excel file.It shows file copied.but I unable to find the excelsheet that I given in the path.
Could you please tell me where its stored.Or did i misunderstood the concept of BCP export?
here is my query
DECLARE @cmd VARCHAR(255)
SET @cmd = 'bcp "SELECT * FROM database.dbo.vw_Billwise" queryout "D:\testing.xls" -U sa -P mypwd -c'
Exec xp_cmdshell @cmd
Thanks in advance