Table-valued parameters

You can use tables as parameters and pass them to stored procedures. Here is an example:
CREATE TYPE dbo.T1 AS TABLE
(
    C1 BIGINT NOT NULL
);
CREATE PROCEDURE dbo.GetT1
    @Display dbo.T1 READONLY
AS
SELECT * FORM @Display

GO

Leave a Reply

Your email address will not be published. Required fields are marked *