执行查询后的RowCount [英] RowCount after executing a query

问题描述

我有一个查询存储在变量@query

我使用以下语句执行该查询

执行(@query)

我想要通过在SQL Server中执行上述语句返回的行数

I have a query in stored in a variable @query

I execute that query using following statement

execute(@query)

I want the number of rows returned by executing above statement in sql server

How can i get that?

推荐答案

看看@@ROWCOUNT.请参阅 http://technet.microsoft.com/en-us/library/ms187316.aspx [ ^ ].

这篇关于执行查询后的RowCount的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！