原存储过程
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[jiFenTotal]
@in_condition varchar(100),
@jifen int output --我想用这个返回sum(jifen)
AS
Declare @sqlTmp NVARCHAR(500)
set @sqlTmp='SELECT sum(jifen) as jifen from jifenList where '+@in_condition
--set @sqlTmp='SELECT @jifen=sum(jifen) from jifenList where '+@in_condition
-- 想要@jifen能址接得到值啊,要怎么操作
exec sp_executesql @sqlTmp
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER PROCEDURE [dbo].[jiFenTotal]
@in_condition varchar(100),
@jifen int output --我想用这个返回sum(jifen)
AS
Declare @sqlTmp NVARCHAR(500)
set @sqlTmp='SELECT sum(jifen) as jifen from jifenList where '+@in_condition
--set @sqlTmp='SELECT @jifen=sum(jifen) from jifenList where '+@in_condition
-- 想要@jifen能址接得到值啊,要怎么操作
exec sp_executesql @sqlTmp
ALTER PROCEDURE [dbo].[jiFenTotal]
@in_condition varchar(100),
@jifen int output --我想用这个返回sum(jifen)
AS
Declare @sqlTmp NVARCHAR(500)
set @sqlTmp='SELECT sum(jifen) as jifen from jifenList where '+@in_condition
exec sp_executesql @sqlTmp,N'@i int output',@jifen output-
select @jifen
@in_condition varchar(100),
@jifen int output --我想用这个返回sum(jifen)
AS
Declare @sqlTmp NVARCHAR(500)
set @sqlTmp='SELECT @i=sum(jifen) as jifen from jifenList where '+@in_condition
exec sp_executesql @sqlTmp,N'@i int output',@jifen output
select @jifen