bcp limitation | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

bcp limitation

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 Failing to plan is Planning to fail
Put the query in a view or in a Sp

Dinesh, I already did that and that worked
Madhivanan Failing to plan is Planning to fail
I think so about the query character length in BCP, I feel Dinesh’s suggestion is only way to go. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.