如何用python遍历SQLServer数据库中某个表的所有记录，并修改。

Question

想用python遍历某个数据库中的一个表，依次读出每条记录，并修改保存。
请问该如何编写代码？谢谢

Answer 1

declare @row varchar(30)
declare @tbname varchar(30)
DECLARE string_find_cursor CURSOR FAST_FORWARD FOR

SELECT [name]

FROM sysobjects where type='U' and name like 'A%'
ORDER BY [name]

OPEN string_find_cursor

FETCH NEXT FROM string_find_cursor

INTO @tbname

WHILE @@FETCH_STATUS = 0

BEGIN

--select @row=count(*) from @tbname
select @row=rows from sysindexes where id = object_id(cast(@tbname as varchar(30))) and indid in (0,1)
if(cast(@row as int))>0
print @tbname+' '+@row+' '+'select * from '+@tbname
FETCH NEXT FROM string_find_cursor

INTO @tbname

END

CLOSE string_find_cursor

DEALLOCATE string_find_cursor

参考 ： https://blog.csdn.net/my98800/article/details/76602277

你可以看看