Server identifier
mariela_montero_at_ncsu.edu
Date: 09/10/04
- Next message: Tarang Deshpande: "Re: Exclusive Query"
- Previous message: Vishal Parkar: "Re: Exclusive Query"
- Next in thread: Nigel Rivett: "RE: Server identifier"
- Reply: Nigel Rivett: "RE: Server identifier"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 10 Sep 2004 07:38:23 -0700
I am working with sql server trying to conect to a sybase
server. Trying to use the following statement:
exec open_acs_dds...rp_sqlredirect hrl_extract,"select *
from hrl_fall_99_id_view where ID>'000000100' and
((BldgName>'A' and BldgRegion <>'V') or HousingStatus
like 'C%') order by
ID",acs_dds,nteldsb,nteldsb,NTFLOW,acs_dds,acs_dds,housing_
vue2
I am getting this error:
Server: Msg 103, Level 15, State 7, Line 1
The identifier that starts with 'select * from
hrl_fall_99_id_view where ID>'000000100' and
((BldgName>'A' and BldgRegion <>'V') or HousingStatus
like 'C%') orde' is too long. Maximum length is 128.
Thanks
Mariela Montero
- Next message: Tarang Deshpande: "Re: Exclusive Query"
- Previous message: Vishal Parkar: "Re: Exclusive Query"
- Next in thread: Nigel Rivett: "RE: Server identifier"
- Reply: Nigel Rivett: "RE: Server identifier"
- Messages sorted by: [ date ] [ thread ]