title: Create T-SQL Function with table parameter
body: <p>I needed to write function with table parameter.</p>
  
  <p>an example: </p>
  
  <pre><code>CREATE FUNCTION getParentByBrandList
  ( @_BrandList TABLE(
                          BR_ID INT, BR_Name NVARCHAR(150), BR_ParentBrandID INT, BR_MasterBrandID INT, BR_Role INT,
                          BR_State INT, BR_OwnerID INT, BR_OwnerIP NVARCHAR(50), BR_CreateDate DATETIME, BR_UpdaterID INT,
                          BR_UpdaterIP NVARCHAR(50), BR_UpdateDate DATETIME
                         ) 
  )
  </code></pre>
  
  <p>How can I do?</p>
  
  <p>Thanx</p>