sqlserver js脚本实现传参到sql存储过程

 var sqlStatement="DECLARE @tmpRows as test_tp_NextNodeFlowsBatchInsert;DECLARE @Managers as test_tp_Managersinfo;INSERT @tmpRows values "+ sqlstr +";INSERT @Managers values "+ sqlstr_M +";EXEC dbo.test_CPP_NextNodeFlowsBatchInsert @tmpRows,@Managers";

定义表类型参数 @tmpRows ,@Managers

路径：数据库->可编程性->类型->用户定义表类型->新建用户定义表类型

如：

CREATE TYPE [dbo].[test_tp_NextNodeFlowsBatchInsert] AS TABLE(
[App_ID] [varchar](100) NOT NULL,
[AppT_ID] [varchar](50) NOT NULL,
[Instance_Name] [varchar](500) NOT NULL,
[Instance_ID] [varchar](50) NOT NULL,
[AppD_ID] [varchar](50) NOT NULL,
[TargetID] [varchar](50) NOT NULL,
[AppI_Content] [varchar](500) NULL,
[LoginDept] [varchar](50) NULL,
[BU] [varchar](50) NULL,
[Version] [varchar](50) NULL,
PRIMARY KEY CLUSTERED
(
[Instance_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)
GO