34,587
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE QKG
@KK VARCHAR(20) ,
@LL VARCHAR(20)
AS
DECLARE @SQL1 NVARCHAR(2000);
SET @SQL1 = 'UPDATE ' + @KK + ' SET ' + @LL + ' = LTRIM(RTRIM(REPLACE(REPLACE(REPLACE('+@LL+',CHAR(13)+CHAR(10),''''),CHAR(13),''''),CHAR(10),'''')))';
EXEC sp_executesql @SQL1;
GO
EXEC QKG 查封0905$, 业务件号;
DECLARE @kK VARCHAR(100)='Test_Table',@LL VARCHAR(1000)='TestName'
DECLARE @sql NVARCHAR(max)
SET @sql='UPDATE [' +@kK +'] SET ['+@LL +']=RTRIM(LTRIM(REPLACE(REPLACE(['+@LL+'],CHAR(13),''''),CHAR(10),'''')))'
PRINT @sql
EXEC sys.sp_executesql @sql