GO
/****** 对象: StoredProcedure [dbo].[sp_RowCount] 脚本日期: 04/21/2012 12:02:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: 爱因光
-- Create date: 2012年4月21日
-- Description: 快速获取指定表的行数
-- =============================================
ALTER PROCEDURE [dbo].[sp_RowCount]
@table NVARCHAR(30)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @tb TABLE(name SYSNAME,[RowCount] NVARCHAR(4000),c NVARCHAR(4000),d NVARCHAR(4000),e NVARCHAR(4000),f NVARCHAR(4000))
INSERT INTO @tb EXEC sp_spaceused @table
SELECT TOP 1 [RowCount] FROM @tb
END