1.定义表值类型
CREATE TYPE [dbo].[TableType] AS TABLE(
[Id] [varchar](20) NOT NULL,
[Num] [int] NOT NULL,
[Used_DoseCount] [decimal](18, 4) NULL
2.定义存储过程
CREATE PROCEDURE [dbo].[MyProc]
@demo TableType readonly,--使用表值参数,参数必须设置readonly
@C char(2)
@D varchar(56)
AS
BEGIN
--存储过程主体
END
3.调用
declare @t as TableType
insert @t select '405',10, 1
insert @t select '705',10, 1
insert @t select '394',10, 1
exec MyProc @t,'11','1111'