Cursors (Transact-SQL) Cursors (Transact-SQL) Article02/28/2023 In this article Applies to:
SQL Server Azure SQL Database Azure SQL Managed Instance Microsoft SQL Server statements produce a complete result set, but there are times when the results are best processed one row at a time. Opening a cursor on a result set allows processing the result set one row at a time. You can assign a cursor to a variable or parameter with a cursor data type. Cursor operations are supported on these statements: CLOSE CREATE PROCEDURE DEALLOCATE DECLARE CURSOR DECLARE @local_variable DELETE FETCH OPEN UPDATE SET These system functions and system stored procedures also support cursors: @@CURSOR_ROWS CURSOR_STATUS @@FETCH_STATUS sp_cursor_list sp_describe_cursor sp_describe_cursor_columns sp_describe_cursor_tables See Also Cursors
2024最新激活全家桶教程，稳定运行到2099年，请移步至置顶文章：https://sigusoft.com/99576.html
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请联系我们举报，一经查实，本站将立刻删除。 文章由激活谷谷主-小谷整理,转载请注明出处：https://sigusoft.com/87113.html
