I have declared the following user defined table type
CREATE TYPE [component].[programmeList] AS TABLE ( ProgrammeId [bigint] NOT NULL ) GO
Now when i pass it as parameter to an SP
SET QUOTED_IDENTIFIER ON; SET ANSI_NULLS ON; GO CREATE PROCEDURE [component].[Get_Live_Examination_Status] @AssessmentPeriodId INT, @ResponseFormatType INT, @ProgrammeList AS component.programmeList AS BEGIN
I keep getting the following error
Parameter or variable has invalid datatype
Advertisement
Answer
You must pass this argument as :
@ProgrammeList component.programmeList READONLY