大神解决一条sql语句问题~~~~~~~~~~~在线等待

zhulong1111 2016-12-13 07:25:18



alter PROC PROC_TEST 

@aaa nVARCHAR(100)

AS

begin

DECLARE  @idCount int,@sql nvarchar(100);

print @aaa;

--exec( ' set '+@idCount+'=(SELECT COUNT(*) FROM '+ @aaa+')')

SET @sql='SELECT '+@idCount+'=COUNT(*) FROM '+QUOTENAME(@aaa)+' '

EXEC sp_executesql @sql;

print @idCount;

end

问题：一个存储过程传参，参数为表名。在存储过程中实现 select查询语句查询的结果总数赋值给存储过程中声明的变量。。求解

...全文

437 4 打赏收藏转发到动态举报

写回复

用AI写文章

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

EnForGrass 2017-02-13

打赏
举报


Create PROCEDURE [dbo].[TT]
-- Add the parameters for the stored procedure here
@aaa nVARCHAR(100)
AS
begin
DECLARE  @sql nvarchar(100);

--exec( ' set '+@idCount+'=(SELECT COUNT(*) FROM '+ @aaa+')')
SET @sql='SELECT COUNT(*) FROM '+QUOTENAME(@aaa)+' '
EXEC sp_executesql @sql;

end

Mrince 2017-02-13

打赏
举报

ALTER PROCEDURE [dbo].[TT] -- Add the parameters for the stored procedure here @aaa nVARCHAR(100) AS begin DECLARE @sql nvarchar(100); --exec( ' set '+@idCount+'=(SELECT COUNT(*) FROM '+ @aaa+')') SET @sql='SELECT COUNT(*) FROM '+QUOTENAME(@aaa)+' ' EXEC sp_executesql @sql; end

castyoung 2016-12-13

打赏
举报

alter PROC PROC_TEST @aaa nVARCHAR(100) AS begin DECLARE @idCount int,@sql nvarchar(100); print @aaa; SET @sql='SELECT @idcount = COUNT(*) FROM '+QUOTENAME(@aaa)+' ' EXEC sp_executesql @sql,N'@idcount int output ',@idcount output ; print @idCount; end

zhulong1111 2016-12-13