title: drop rows in a user defined table type
body: <p>i have the following type:</p>
  
  <pre><code>CREATE TYPE [dbo].[locationTable] AS TABLE(
  [location_id] [varchar](100) NULL,
  [name] [nvarchar](100) NULL,
  [address] [varchar](100) NULL,
  [latitude] [varchar](100) NULL,
  [longitude] [varchar](100) NULL,
  [distance] [varchar](100) NULL,
  [state] [varchar](100) NULL,
  [sub_cat] [varchar](100) NULL,
  [idCat] [varchar](100) NULL,
  [icon_link] [varchar](100) NULL,
  [checkinsCount] [int] NULL
  )
  GO
  </code></pre>
  
  <p>and i'm passing a table as parameter having the above type to a stored procedure... but i need to delete some rows from this table in my stored procedure but i keep getting that it cannot be modified.... sql is always requesting to define the table as readonly and in this case i can not modify</p>