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
