How to pass table as parameter in stored procedure

In this post I will explain how to pass table as parameter in stored procedure with example. Table-Valued Parameters is a new feature of Microsoft SQL Server 2008. In earlier versions of SQL Server it is not possible to pass table variable in store procedure as parameter.