IF EXISTS (SELECT * FROM sys.types WHERE is_table_type = 1 AND name = 'TestPassList')
DROP TYPE TestPassList
GO
CREATE TYPE dbo.TestPassList
AS TABLE
(
BookingIdMaster INT,
BookingId INT
);
GO
CREATE PROCEDURE sp_TestPassList
@List AS dbo.TestPassList READONLY
AS
BEGIN
SELECT *
FROM @List
END
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'fn_TestPassList') AND type in (N'P', N'TF'))
DROP FUNCTION fn_TestPassList
GO
CREATE FUNCTION fn_TestPassList(@List AS dbo.TestPassList READONLY)
RETURNS @temptable
TABLE (
BookingId INT
)
AS
BEGIN
INSERT INTO @temptable
SELECT BookingId
FROM @List
RETURN
END
GO
----------- test
DECLARE @TestPassListVar dbo.TestPassList
INSERT INTO @TestPassListVar
SELECT TOP 10 billing_id Booking_IdMaster,
Booking_Id
FROM d_booking
SELECT *
FROM fn_TestPassList(@TestPassListVar)
Category :
Time: 9:29 PM
Subscribe to:
Post Comments (Atom)

0 comments:
Post a Comment