python-在sql server中调用过程时，将uniqueintlist数据类型作为参数传递

Question

我需要从python执行一个过程，如下所示：

DECLARE @LayoutID INT = 9,
        @PrivateFL INT = 0,
        @FromDate DATETIME = '20100101',
        @ToDate DATETIME = '20211001',
        @VesselIDs dbo.UniqueIntList

INSERT INTO @VesselIDs 
VALUES (202), (330)

EXEC usp_GetComments @LayoutID, @PrivateFL, @FromDate, @ToDate, @VesselIDs

在使用Python执行它时，如何将@vesselids作为参数？

我尝试了此代码，但它不起作用

list = [202,330]

storedProc = "EXEC usp_GetComments @LayoutID=?, @PrivateFL=?, @FromDate=?, @ToDate=?, @VesselIDs=?"

params = (9,0,'20100101','20211001',list)

Answer 1

如下：

storedProc = "EXEC usp_GetComments @LayoutID=?, @PrivateFL=?, @FromDate=?, @ToDate=?, @VesselIDs=?"


fktvp = [(202,),(330,)]
fkparams = (9,0,'20100101','20211001',fktvp)
 

cursor.execute( storedProc, fkparams )