如何在此Microsoft SQL语句中获取行计数 [英] How do I get the row count in this Microsoft SQL statement

问题描述

 CREATE PROCEDURE [dbo]。[TableRowCount] 
 @tableName text，
 @count int OUTPUT 
 AS 
 EXEC（'SELECT * FROM' + @tableName）
 SET @count = @@ ROWCOUNT 
 RETURN @count 

解决方案

检查下面

http： //stackoverflow.com/questions/20562688/count-number-of-records-of-a-dynamic-build-query-into-a-variable [ ^ ]

为什么不简单地

  SELECT  COUNT（TableName.TablePK）< span class =code-keyword> FROM  TableName 
   -   因为SELECT *是一个非常糟糕的习惯 

？

CREATE PROCEDURE [dbo].[TableRowCount]
	@tableName text,
	@count int OUTPUT
AS
	EXEC('SELECT * FROM ' + @tableName)
	SET @count = @@ROWCOUNT
RETURN @count

解决方案

check below
http://stackoverflow.com/questions/20562688/count-number-of-records-of-a-dynamic-build-query-into-a-variable[^]

Why not just simply

SELECT COUNT(TableName.TablePK) FROM TableName
-- Because SELECT * is a really bad habit

?

这篇关于如何在此Microsoft SQL语句中获取行计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！