Podskazhite pozhaluista ,kakaya maximaljnaya dlinna mozhet bitj u SQL statementa peredavaemogo ODBC pass-through.

Gde-to videl otvet , no naity ne smog (vidimo meshayut 2 x 0.7 suhogo vina vipitgo vchera).

Sorry,
zabil opisatj pronblemu.

Estj MS Excel2000 reporti (shtuk 300).
tablici zapolnyautsya cherez vizov stored procedures na SQL2000 Excelevskim add-inom Excelerator cherez ODBC.

Nachaljnik hokchet chto bi vmesto vizova proceduri, iz Excel peredavalsya SQL statement, potomu chto krome menya nikto iz nashih 9-ti DB Developerov NE MOZHET poljzovatjsya Query Analyserom (vse vsegda vsyo pisali v MS Query, a etot russkiy parazit opyatj vsyo uslozhnyaet).

Otmazki tipa "eto zh budet medlennee, krivee itd" ne prokativayut.

Proceduri bivayut razmerom ot 2kb do 200kb (detailed description vnutry procedury obyazateljno - eto company policy).

Vot vspomnil , chto u ODBC bil limit na razmer peredavaemogo SQL statementa.
A kakoi ne pomnu.

Spasite, a to ya chyoknusj, na MS Query pisatj.

Nashiol

String Limitations
The maximum length of an SQL statement string is 65,000 characters...


© 1998-2003 Microsoft Corporation. All rights reserved.