T-SQLpowered

Table Type

Declare with PK constraint, insert and retrieve data:

CREATE TYPE [dbo].[utt_Generic_Int] AS TABLE
(
	[Id] [INT] NOT NULL PRIMARY KEY CLUSTERED 
)
GO

DECLARE @Ids utt_Generic_Int

INSERT INTO @Ids
	( [Id] )
VALUES
	(1), (2), (3) 
	
SELECT *
FROM @Ids
GO