pyodbc/ceodb中表变量的创建

Question

在pyodbc和ceodbc中，声明一个表变量，在其中插入一些数据，然后从中进行选择，似乎都不起作用。在

cursor.execute("""
DECLARE @LOG TABLE 
    (ID varchar(10))

INSERT INTO @LOG (ID)

SELECT TOP 10 ID
FROM NAME

SELECT ID
FROM @LOG
""")

------------------------------------------------------------
Traceback (most recent call last):
  File "<ipython console>", line 1, in <module>
ProgrammingError: No results.  Previous SQL was not a query.

我不知道这是一个真正的问题，还是有一个诀窍使它发挥作用。SELECT语句在我的设置中总是运行良好。在

Answer 1

哦。：操作

cursor.execute("""

SELECT ID
FROM 

(SELECT TOP 10 ID
FROM NAME)

LOG

""")

In [49]: cursor.fetchall()
Out[49]: 
[('1', ),
 ('10', ),
 ('100000', ),
 ('100001', ),
 ('100002', ),
 ('100003', ),
 ('100004', ),
 ('100005', ),
 ('100006', ),
 ('100007', )]