c# - Setting nvarchar length to maximum in table valued parameters -
i want pass table valued parameter variable stored procedure , in constructor of class sqlmetadata
1 can specify length (long maxlength) of string 1 wants add in column of table.
microsoft.sqlserver.server.sqlmetadata[] tvpdefinition = { new sqlmetadata("valueone", sqldbtype.nvarchar, 100), new sqlmetadata("valuetwo",sqldbtype.nvarchar, 100) }
how can 1 go specifying 'max' length corresponds column
valueone (nvarchar(max), not null)
as opposed length value of 100 example
in article on msdn specified can set max size in way
sqlparameter myparam = new sqlparameter("@paramname", sqldbtype.nvarchar, sqlmetadata.max );
see last example on above mentioned article.
so, without knowing how sqlmetadata class defined, , supposing last parameter size propery of underlying sqlparameter, think write
microsoft.sqlserver.server.sqlmetadata[] tvpdefinition = { new sqlmetadata("valueone", sqldbtype.nvarchar, sqlmetadata.max ), .... }
Comments
Post a Comment