Parameters in RS

Hi All,
Wats the maximun size for the parameters in SQl'
I have a string parameter and if a paa about 130 characters... Its getting
truncated ...
Any help please..
Thanks,depends on the datatype but I think 8000 for a char or varchar
also depends on case 4000 if you are case dependent
"CCP" wrote:
> Hi All,
> Wats the maximun size for the parameters in SQl'
> I have a string parameter and if a paa about 130 characters... Its getting
> truncated ...
>
> Any help please..
>
> Thanks,|||Unless, of course, the parameter is being passed via the querystring, at
which point it is restricted by the maximum length of the URL:
http://support.microsoft.com/default.aspx?scid=kb;en-us;208427
Mike G.
"letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
news:AF5AFF64-8683-42F5-BBE3-47EECCC31C98@.microsoft.com...
> depends on the datatype but I think 8000 for a char or varchar
> also depends on case 4000 if you are case dependent
>
> "CCP" wrote:
>> Hi All,
>> Wats the maximun size for the parameters in SQl'
>> I have a string parameter and if a paa about 130 characters... Its
>> getting
>> truncated ...
>>
>> Any help please..
>>
>> Thanks,|||Hi ,
Thanks for the quick response.
Im not passing them in the query string...
I could execute the sp in the query analyser without any probs...
only when i run the report the parameter is getting truncated...
not sure where the prob is'
Any help please...
"Mike G." wrote:
> Unless, of course, the parameter is being passed via the querystring, at
> which point it is restricted by the maximum length of the URL:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;208427
> Mike G.
>
> "letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
> news:AF5AFF64-8683-42F5-BBE3-47EECCC31C98@.microsoft.com...
> > depends on the datatype but I think 8000 for a char or varchar
> >
> > also depends on case 4000 if you are case dependent
> >
> >
> >
> > "CCP" wrote:
> >
> >> Hi All,
> >> Wats the maximun size for the parameters in SQl'
> >> I have a string parameter and if a paa about 130 characters... Its
> >> getting
> >> truncated ...
> >>
> >>
> >> Any help please..
> >>
> >>
> >> Thanks,
>
>