Can a stored procedure with table-type parameters be called in Haskell? If I have the following table, type, and procedure in SQL Server, how do I call the procedure from Haskell when its argument is a table type?
CREATE TABLE dbo.Category (
CategoryID int,
CategoryName nvarchar(50)
)
GO
CREATE TYPE dbo.CategoryTableType AS TABLE
( CategoryID int, CategoryName nvarchar(50) )
GO
CREATE PROCEDURE InsertCategories
(@NewCategories dbo.CategoryTableType READONLY)
AS
BEGIN
INSERT INTO dbo.Category (CategoryID, CategoryName)
SELECT nc.CategoryID, nc.CategoryName FROM @NewCategories AS nc
END