sqlAdapter.SelectCommand.Parameters.Add

  • Thread starter Thread starter Ondrej Sevecek
  • Start date Start date
O

Ondrej Sevecek

Is there neccessary to specify length of the parameter added, especially for
NVarChar parameters?
What will be the default behaviour, when the parameter length will not be
specified?

Ondra
 
why? Stored procedure will have the size specified itself. Are there some
drawbacks without using the size?

Ondra
 
that way, you are telling to .Net that you need to occupy specific
size of memory aread for the parameter. so, it helps to optimize the
things.

Rajesh Patel
 
Back
Top