使用表值引數將多行插入表中
首先,定義要使用的已定義表型別 :
CREATE TYPE names as TABLE
(
FirstName varchar(10),
LastName varchar(10)
)
GO
建立儲存過程:
CREATE PROCEDURE prInsertNames
(
@Names dbo.Names READONLY -- Note: You must specify the READONLY
)
AS
INSERT INTO dbo.TblNames (FirstName, LastName)
SELECT FirstName, LastName
FROM @Names
GO
執行儲存過程:
DECLARE @names dbo.Names
INSERT INTO @Names VALUES
('Zohar', 'Peled'),
('First', 'Last')
EXEC dbo.prInsertNames @Names