SQL command parameters size

[samerh]

Hi all i need to know exactly the size of sql parameters when definning them. Ex: SqlParameter foo = new SqlParameter(parameterName, dbType, size); this.Add(foo); I need to know size that should be send for each datatype, Ex: Bigint, float, varchar(max)... Thanks

[Ravikumar Commuri]

Hi you can give the max size as per ur requirement. But you have to follow while declaring the size of the parameter is not less than than the size of the parameter that u have declared in your stored proc's

[samerh]

Thanks for ur reply This is what iam doing right now decaring the size the same as i declare them in stored procedures. But for some types there is a default or max size we should commit to. Is there a list where i can get these defaults? Thanks