今天碰到需要调试存储过程,而且调用了用户定义表类型,查了百度,找了相对应的东西,为了避免自己忘了,发个随笔
DECLARE @pArray UpdateTerminalsParam insert into @pArray (调用的用户定义表类型) ([Status], [RatePlanName], [RatePlanCount], [RatePlanStr], [TotalFlowMB], [MonthToDateDataUsageMB], [MonthToDateSmsUsage], [lat], [lon], [ICCId], [Msisdn], [ActiveTime], [SynchroError]) values (2,'',0,'',10,0,0,0,0,'898602B6101740480056','1064868970174','','') exec PROC_UpdateTerminals @pArray,1,'true'