sql server中的回车换行字符是
char(13)+
char(10)
-- ================================================================
-- 用指定的字符替换字段中‘回车’和‘换行’符
-- =================================================================
create FUNCTION dbo.udf_replace
(
@s varchar(8000),
@split varchar(10)
)
RETURNS varchar(8000)
AS
BEGIN
declare @strtemp varchar(8000)
select @strtemp = REPLACE(@s, CHAR(13)+ CHAR(10),@split)
return @strtemp
END
GO
使用:
declare @str varchar(255)
set @str =' abc
xyz
cfg'
--如上所示..注意变量@str中含有三个回车换行符。
select dbo.udf_replace(@str,'||') as fldName
运行后,输出将如下所示:
fldName
------------------------
1 abc||xyz||cfg
-----------------------------
(1 row(s) affected)
<script type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script>
-- ================================================================
-- 用指定的字符替换字段中‘回车’和‘换行’符
-- =================================================================
create FUNCTION dbo.udf_replace
(
@s varchar(8000),
@split varchar(10)
)
RETURNS varchar(8000)
AS
BEGIN
declare @strtemp varchar(8000)
select @strtemp = REPLACE(@s, CHAR(13)+ CHAR(10),@split)
return @strtemp
END
GO
使用:
declare @str varchar(255)
set @str =' abc
xyz
cfg'
--如上所示..注意变量@str中含有三个回车换行符。
select dbo.udf_replace(@str,'||') as fldName
运行后,输出将如下所示:
fldName
------------------------
1 abc||xyz||cfg
-----------------------------
(1 row(s) affected)
<script type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script>