Insert Multiple Rows into Table using User Defined Table Type as Parameter in Stored Proc SQL - 1

Hello guys, In this video I have demonstrated how to insert multiple rows into a table using the stored procedure. Here I have created a user-defined table type as a parameter in a stored procedure and then using that SP I am inserting more than one row in one go. Using Table-valued parameters in an SQL server is a super easy thing to do and you will come to know that after viewing this video.
I have used a notepad in this tutorial to keep all SQL Queries at a place and I have also mentioned the link of that notepad data below. You can go ahead and click on that URL.
I have also used a PPT for step by step demonstration about how to pass user-defined table type as a parameter in the stored procedure. You can also find that presentation URL below.
In this video, you will also learn that how to update multiple rows with different values in the SQL server after passing each and every row as a Table Valued parameter at once.
This video also related to delete multiple rows in SQL with different values.

Presentation URL for table-valued parameters:

Notepad URL for getting the SQL script related to user-defined table type in SQL server:

Book for learning ASP.NET:

Go to this link to take the test to identify yourself.

[theITvideos]

Thanks heaps! I was actually looking for the UPDATE operation in the value parameter. Very helpful i have subscribed to your channel.

[rinkulsharma]

what if i want to insert 100 records but not from any other table, it should be dummy data for test and with few dynamic values like sysdate and id like G_leg_0001 thrn G_leg_0002 and so on ?