Introduction : 

              Hi, here i will explain how to create the user-defined table types in SQL server, which is commonly used to insert or update the multiple records from the front-end applications.

My table Structure as Shown below, the column declared in the User-defined table type should be present in the Table where the records are going to insert.

Table Name : StudentDetails

Create Userdefined table Type :

Create Type Type_StudentDetails as Table
(
StudentName varchar(300) null,
RegistrationNumber varchar(20) null,
Department varchar(500) null,
FatherName varchar(300) null
)

Cleck here to see  how to call User-Defined table type in Store procedure