Question : All of my tables have those two columns: [Id] [uniqueidentifier] NOT NULL [Revision] [bigint] IDENTITY(1, 1) NOT NULL […]
Get name and definition of all table types
Question : I know how to create a table type (to be used as a table-valued parameter) – but once […]
why unable to execute table-valued function?
Question : Here is table-value function I have declared like: CREATE FUNCTION fn_GetMedian(@List TypeMedian READONLY) RETURNS INT AS BEGIN RETURN […]
How to acquire a table result set from “Table – valued function” when the result set has variable structures?
Question : I need to write a Table – valued function from which I can acquire a table result set […]
Table Value Constructor as Procedure Parameter
Question : I can find information on creating procedures with table-valued parameters, and information on table literals, but I can’t […]
Delete rows in a table based on a table value parameter
Question : I have a table A and a user defined table type on which a table value parameter (tvp) […]
Can you create a table param WITHOUT a pre-defined TVP in a SP?
Question : In the body of an SP I have the following line of code: DECLARE @assetCode NVARCHAR(50) = ( […]
View Existing Table-valued Parameters
Question : I have seen many tutorials on how to create a table-valued parameter – but how do you view […]
Generic TVP tradeoffs?
Question : Is there a best practice or strategy for table types used in TVPs? For instance, given the following: […]
Why does this TVF throw error 9820 with GETDATE() as an input parameter?
Question : I am testing on SQL Server 2019 CU14. Consider the following table-valued function created against a SQL Server […]