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

exec(@sql)

END