34,589
社区成员
发帖
与我相关
我的任务
分享
exec Fx_Proc_GetCostType @FBegDate= '{beginDate}', @FEndDate = '{endDate}',@fnumber = '{fnumber}'
INSERT INTO [LNM-Cost].[dbo].[LNMCost_SqlText]
([HNumber]
,[HSqlText]
,[HNotes])
VALUES
('GetReportData_54'
,'exec Fx_Proc_GetCostType @FBegDate='+'''' + {beginDate} + ''''+', @FEndDate = '+'''' + {endDate} + ''''+',@fnumber = '+'''' + {fnumber} + ''''
,'获取整机明细')
DECLARE @str NVARCHAR(100)
EXEC @str= Fx_Proc_GetCostType @FBegDate = '{beginDate}',
@FEndDate = '{endDate}', @fnumber = '{fnumber}'
INSERT INTO [LNM-Cost].[dbo].[LNMCost_SqlText]
( [HNumber] ,
[HSqlText] ,
[HNotes]
)
VALUES ( 'GetReportData_54' ,
@str ,
'获取整机明细'
)