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

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

javascript - jQuery show full size image on click -