Execute stored procedure with table values as parameter

Question

I create own table type

CREATE TYPE [dbo].[ObjectsList] AS TABLE( [Id] [int] NOT NULL, PRIMARY KEY CLUSTERED  (    [Id] ASC )WITH (IGNORE_DUP_KEY = OFF) ) GO 

and when I want to pass this Type as parameter like

CREATE PROCEDURE [dbo].[GetData](@DataIds ObjectsList READONLY) 

how should I pass it in EXEC GetData ????

Answer 1

Look at this

You can find an example

DECLARE @data ObjectList INSERT @data (Id) VALUES (1) EXEC GetData @data