#ExecuteStoreProcedure #MSSQL, How can i pass cdt as an input to Execute Store P

Hi pankaj,
As per my knowledge. You can not pass the cdt as parameter to Stored procedure .. Why becz there is no input type cdt in db.. Even if u r pass it takes as string type not as cdt type..

You can do one thing , pass the id or any unique column to Sp and fetech all column and do your funtionality..

Thanks Bhanu, we have a requirement where we need to paas cdt(multiple) as input to create records in DB, we dont want to use write data service, there is user Defined Table Type variables in MSSQL DB which can handle like cdt with multiple records.

@pankajk It might be worth taking a look at an approach where the multiple cdt is passed as an xml string to SP and the the SP parses the xml string in its body.