如可读取存储过程

[dxai]

- =============================================
-- Pro_find_table_data_num
--===功能：查找表在给出的表、字段名、数据值，查找数据值出现的次数
-- =============================================
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = 'Pro_find_table_data_num'
AND type = 'P')
DROP PROCEDURE Pro_find_table_data_num
GO

CREATE PROCEDURE Pro_find_table_data_num
@table_name varchar(20),
@column_name varchar(20),
@data_num varchar(20),
@li_return numeric(5) output
AS
Declare @str_sql varchar(500)
--===构造sql
set @str_sql='Select count(*) as Num From '+@table_name+' where '+@column_name+' ='+@data_num
--===执行sql
Exec(@str_sql)
--print @str_sql
--Select @li_return=(select count(*) From goods_view where goods_xb='100020')



GO
declare @num varchar(20)
Declare @li_val numeric(5)
set @num='100020'
set @li_val=0
exec pro_find_table_data_num 'goods_view','goods_xb',@num ,@li_val output
print @li_val
问：
如何得到@li_val的值？

[NinGoo]

使用sp_executesql

[NinGoo]

o ,没看清题目，8好意思

[dxai]

请高手.