Is there any limitation on the length of the query used? When the query
exceeds 128 characters, I get the error

Server: Msg 103, Level 15, State 7, Line 1
The identifier that starts with 'Select Id,Name,Descrip, Address,
others,
case when len((Select distinct Street from mydb..testw2 where w2' is
too long. Maximum length is 128.


Madhivanan

You can use a view and then bcp from it.

Is there any limitation on the length of the query used? When the query
exceeds 128 characters, I get the error

Server: Msg 103, Level 15, State 7, Line 1
The identifier that starts with 'Select Id,Name,Descrip, Address,
others,
case when len((Select distinct Street from mydb..testw2 where w2' is
too long. Maximum length is 128.


Madhivanan

Can you post the exact command you are excuting?. BCP expects double
quotation marks around the query and single quotation marks around anything
embedded in the query. For some reason, sql server is interpreting the query
as an identifier and the max length for identifiers is 128. Check database
option "quoted identifier" using sp_dboption or use SET QUOTED_IDENTIFIER in
the batch.


AMB

Show quoteHide quote

Error converting data type nvarchar to int.
move records from table1 to table2 if does not exist in table3
Query Help
FIFO report
Performance Issues using Aggregate MAX function within a temp table