更新时间:2022-11-28 18:41:42
您是在Type定义中选择的,而不是参数。尝试以下操作:
You are selecting from the Type definition, not the parameter. Try this:
CREATE PROCEDURE [dbo].[sp_InsertUser]
-- Add the parameters for the stored procedure here
@UserTableType UserTableType READONLY
AS
BEGIN
INSERT INTO tblUser
SELECT * FROM @UserTableType
END