table-valued-parameters Archives

SQL Server: Pass table name into table valued function as a parameter

By adminPosted on March 27, 2023

Question : All of my tables have those two columns: [Id] [uniqueidentifier] NOT NULL [Revision] [bigint] IDENTITY(1, 1) NOT NULL […]

By adminPosted on December 11, 2022

Question : I know how to create a table type (to be used as a table-valued parameter) – but once […]

By adminPosted on May 8, 2022

Question : Here is table-value function I have declared like: CREATE FUNCTION fn_GetMedian(@List TypeMedian READONLY) RETURNS INT AS BEGIN RETURN […]

By adminPosted on April 21, 2022

Question : I need to write a Table – valued function from which I can acquire a table result set […]

By adminPosted on December 2, 2021

Question : I can find information on creating procedures with table-valued parameters, and information on table literals, but I can’t […]

By adminPosted on June 21, 2021

Question : I have a table A and a user defined table type on which a table value parameter (tvp) […]

By adminPosted on March 20, 2021

Question : In the body of an SP I have the following line of code: DECLARE @assetCode NVARCHAR(50) = ( […]

By adminPosted on December 29, 2020

Question : I have seen many tutorials on how to create a table-valued parameter – but how do you view […]

By adminPosted on August 8, 2020

Question : Is there a best practice or strategy for table types used in TVPs? For instance, given the following: […]

By adminPosted on March 13, 2020

Question : I am testing on SQL Server 2019 CU14. Consider the following table-valued function created against a SQL Server […]