@DevendraP17332832 

To pass a table-type parameter (also known as a user-defined table type) to a stored procedure in SQL Server, you first need to create a User-Defined Table Type using CREATE TYPE. This type defines the structure of the table (columns and their data types). Once created, you can use it as a parameter in your stored procedure definition with the READONLY keyword, because table-valued parameters can only be read, not modified, inside the procedure. In your application or script (e.g., using T-SQL or from code like C#, Java, or Pega), you create a variable or data table matching this type and populate it with rows. Then, you pass it as an argument when calling the stored procedure. This is useful when you want to send multiple rows of data in one call to the database.

Would you like an example using SQL Server and Pega or another platform?