How to use the user-defined TABLE TYPE or Table-Valued parameters in SQL Server.

Learn how to define a user-defined table type.

Table-valued parameters are declared by using user-defined table types.

a) define a variable as table aka; user defined user-defined table types
b) load table with records, just like as-if a real table
c) pass tabled-valued parameters to a stored procedure.
d) create user-defined table type

------------------------------------------------------*****------------------------------------------------------------
If you've found this videos useful and wish to show your support with a small XLM donation, feel free to use the following values:

XLM address
GC23BCI644P66PPNRGRMKFFVQZZXE3CSCGMFIYFV5OW4WCPM2XICKWQZ

XLM Memo
502087138
------------------------------------------------------*****------------------------------------------------------------

software nuggets

0:16 -- Show Support
0:22 -- create a table type
2:49 -- simple use example
5:03 -- show primary key
6:57 -- update table object
9:19 -- create table
10:13 -- create a stored procedure
11:32 -- exec a stored procedure

Learn how to write a stored procedure, whereas, the input parameter is a user-defined table type.

#softwareNuggets, #sqlServer, #select, #userDefinedTableType, #tableType, #udtt

[tanglesite]

This was great! I am in University, and they way they show you in the book, they mention nothing about scope, or the UDT being in memory. They present the content as if they are concrete objects. This helped alot. Finding more advanced material like this is NOT easy. Thanks!

[thaaychannel]

Excellent video and new subscriptions from tamilnadu, India

[ghostrpg]

Thank you very much for the explanation video, appreciate it.

[paulonobre]

When creating a physical table in sql server based on user define Table type is possible to reference only part of the UDT table ?

[nishanthnive]

how to add another column in user defined table type when its reffrd?

[kishorevinee]

Great learning. Can we use table type in another table type definition like one user defined type in another user defined type in Oracle
I need one lecture about how to use Oracle VARRAY functionality in Sql Server