Forum Replies Created

Viewing 3 posts - 1 through 4 (of 4 total)

  • RE: export to csv file from table

    i using bcp command only now.But i need to add header in following code. how use bcp command to add header

    set ANSI_NULLS ON

    set QUOTED_IDENTIFIER ON

    go

    -- =============================================

    -- Author:<Author,,Name>

    -- Create date:...

  • RE: export to csv file from table

    declare @bcpCommand varchar(8000)

    SET @bcpCommand = 'bcp "select * from #Extractemployee" queryout c:\dump.txt -c -STORDBDO1 -Ukumaravels -Pasd123

    I geting error

    SQLState = 08001, NativeError = 53

    Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could...

  • RE: export to csv file from table

    SET @bcpCommand = 'bcp "select * from #Extractemployee" queryout c:\dump.txt -S TORDB01,-U Kumaravels,-P AppsUser'

    i put server name as -S TORDB01

    USER NAME AS -U Kumaravels

    password as -P AppsUser'

    still giving me same...

Viewing 3 posts - 1 through 4 (of 4 total)