Param size

[Jon]

If I specify a type of parameter as varchar or decimal, etc, is there a time
when you are required to specify the size of that param as well. Or is it
safe to simply specify name, direction, type and value? To this point I
have used that and it works fine, but I'm wondering if I may be asking
trouble somewhere down the line. Thanks

--
********************************
Jon

[Greg Burns]

I have always specified the size ('cause I thought I had too). Last week I
was watching a SQL 2005 webcast and the presenter alluded that it was "bad"
to specify the maxsize on a varchar. Not sure what he meant or in what
context. (I know, not very helpful)

AFAIK, including the size in your parameter means just one more place where
you may have to change something if your field size later changes (the
stored procedure being another).

I would like to hear other opinions, cause I really don't know the correct
answer either.

Greg
"Jon" <ru******@msn.com> wrote in message
news:10*************@corp.supernews.com...

If I specify a type of parameter as varchar or decimal, etc, is there a
time
when you are required to specify the size of that param as well. Or is it
safe to simply specify name, direction, type and value? To this point I
have used that and it works fine, but I'm wondering if I may be asking
trouble somewhere down the line. Thanks

--
********************************
Jon

[Cor Ligthert]

Jon,

In addiditon to Greg, I think that for your question this newsgroup is
better for a more in depth opinion.

Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet

Cor