bcp "SELECT * FROM Nav_Test.dbo.TEST_BCP1 a join dbo.TEST_B s on a.Policy = s.PNO " queryout C:\vnk\tst.txt -S (local) -T -n
getting an error
Open the windows command prompt, then go to bcp command which installed (by default) in <drive>:\Program Files\Microsoft SQL Server\100\Tools\Binn. Try the command like this:
bcp "SELECT * FROM Nav_Test.dbo.TEST_BCP1 a join Nav_Test.dbo.TEST_B s on a.Policy = s.PNO " queryout "C:\vnk\tst.txt" -S
<ServerName>\<InstanceName> -T -c
The bold part is different with yours. If it still does not work, post the error message here.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?