sql存储过程
ALTER PROCEDURE frmQueryMonthlySumDQ

--@m_strDrlQD nvarchar(50),

--@m_strMonth1 nvarchar(50),

--@m_strMonth2 nvarchar(50),

--@strSQLWhere nvarchar(500),

@strSQL nvarchar(500),

@strSQL2 nvarchar(500),

@m_strRdoXL nvarchar(50)

AS

BEGIN

declare @strSQL3 nvarchar(1000)

IF(@m_strRdoXL=1)

BEGIN

set @strSQL3=@strSQL+'order by V_BSC.mergercode,XL'

EXEC (@strSQL3)

END

ELSE

BEGIN

set @strSQL3= 'select * from (' + @strSQL + ') as T1,(' + @strSQL2 + ') as T2 where T1.prod = T2.prod order by T1.MERGERCODE,T2.prod'

EXEC (@strSQL3)

END

END

go

我要在执行存储过程的时候输出strsql3，应该怎么做

执行如下



USE [cs]
GO

DECLARE@return_value int

EXEC@return_value = [dbo].[frmQueryMonthlySumDQ]
@strSQL = N'select distinct ISNULL(V_MONTHLYCAN.系列,'' '') as XL, V_BSC.mergercode,V_BSC.mergername as mergername , round(ISNULL(sum((monthlysum.selsell+monthlysum.ensell)*MONTHLYSUM.[convert]),0),0) SELL from MONTHLYSUM,V_BSC,V_MONTHLYCAN where MONTHLYSUM.AREACODE = V_BSC.号码 and MONTHLYSUM.prod=V_MONTHLYCAN.品名 and monthlysum.ymonth>=''201211''and monthlysum.ymonth<=''201211'' and V_MONTHLYCAN.系列 in (''22S-系列'',''75S-系列'') group by V_BSC.mergercode,V_BSC.mergername ,V_MONTHLYCAN.系列 ',
@strSQL2 = N'1',
@m_strRdoXL = N'1'

SELECT'Return Value' = @return_value

GO



[解决办法]
ALTER PROCEDURE frmQueryMonthlySumDQ
@strSQL nvarchar(500),
@strSQL2 nvarchar(500),
@m_strRdoXL nvarchar(50),
@strSQL3 nvarchar(1000) output
AS

BEGIN
IF(@m_strRdoXL=1)
BEGIN
set @strSQL3=@strSQL+'order by V_BSC.mergercode,XL'
EXEC (@strSQL3)
END
ELSE
BEGIN
set @strSQL3= 'select * from (' + @strSQL + ') as T1,(' + @strSQL2 + ') as T2 where T1.prod = T2.prod order by T1.MERGERCODE,T2.prod'
EXEC (@strSQL3)
END
END





[解决办法]
该回复被管理员删除