SQL Server Performance

bcp limitation

Discussion in 'T-SQL Performance Tuning for Developers' started by Madhivanan, May 13, 2005.

  1. Madhivanan Moderator

    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
  2. dineshasanka Moderator

    Put the query in a view or in a Sp
  3. Madhivanan Moderator

    Dinesh, I already did that and that worked


    Madhivanan

    Failing to plan is Planning to fail
  4. satya Moderator

    I think so about the query character length in BCP, I feel Dinesh's suggestion is only way to go.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page