在储存过程中怎样执行这个select 语句
kw816 2006-06-24 05:49:39 CREATE procedure us_example
@Unit varchar(50) --单位名称
as
set nocount on
declare
@sqlstr2 nvarchar(4000) --查询字符串
if (@Unit)="-1"
set @Unit="1=1"
else
set @Unit="ManaUnit="+@Unit
set @sqlstr2="select sum(Dimension) from Field where "+@Unit
--select sum(dimension) from field where Manaunit=@Unit
--怎样执行@sqlstr2变量,使得结果同上一语句一样
set nocount off
GO