欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

ms sql server line feed

程序员文章站 2024-01-20 19:38:22
多行文本换行: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- -- Author: Insus.NET -- Create date: 2019-06-21 -- Update date: 2019-06-21 -- Description: ......

多行文本换行:

 

set ansi_nulls on
go
set quoted_identifier on
go

-- =============================================
-- author:      insus.net
-- create date: 2019-06-21
-- update date: 2019-06-21
-- description: 文本转换
-- =============================================
create function [dbo].[svf_linefeed]
(    
)
returns nvarchar(4000)
as 
begin
    return char(13) + char(10)
end