sql替换_sql替换语句
replace("字段","内容","替换内容");
例如：
ALTER PROCEDURE [dbo].[UP_GetDateRanking]
@Top int=0,
@daytime datetime --查询⽇期
AS
BEGIN
DECLARE @st varchar(20);
DECLARE @et varchar(20);
SET @st=(Select CONVERT(varchar(100), @daytime, 23)+' 00:00:00');
SET @et=(Select CONVERT(varchar(100), @daytime, 23)+' 23:59:59');
DECLARE @topNum varchar(10)
SET @topNum=''
IF @Top>0
SET @topNum=' Top '+ltrim(@Top)
DECLARE @sql varchar(5000)
SET @sql='SELECT @topNum ofId,REPLACE(ofLogin,substring(ofLogin,4,4),''****'') as 商户,(SELECT SUM(ofAmount) FROM IP_OfficeFinance WHERE IP_OfficeFinance.ofId=IP_OfficeInfo.ofId AND ofType=2 and ofTime between '''+@st+''' and
'''+@et+''') AS 总销售额,''暂未开放'' as 奖励积分 FROM  IP_OfficeInfo ORDER BY 总销售额 desc'
set @sql=replace(@sql,'@topNum',@topNum)
print @sql
sql语句替换表中内容exec(@sql)
END

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。