CREATE TYPE MyTableType AS TABLE
(Id INT)
GO
CREATE PROCEDURE MyProcedure
@Ids MyTableType OUTPUT
AS
INSERT INTO @Ids
SELECT object_Id
FROM sys.objects
GO
DECLARE @values MyTableType
exec MyProcedure @Ids=@values OUTPUT
SELECT *
FROM @values
GO
DROP PROCEDURE MyProcedure
GO
DROP Type MyTableType
GO
ไม่มีความคิดเห็น:
แสดงความคิดเห็น