Inserting a line break in the NVARCHAR data in SQL Server


This content was proof-read by Grammarly. You can Try Grammary for FREE

For inserting the character break in a data of type NVARCHAR in SQL Server , you can use CHAR(13).

Inserting a line break in the NVARCHAR data in SQL Server

Inserting a line break in the NVARCHAR data in SQL Server

DECLARE @temp_abundantcode TABLE (
    description NVARCHAR(200)
)

DECLARE @value as NVARCHAR(200)
INSERT INTO @temp_abundantcode VALUES ('This is abundantcode''s' + Char(13) + 'site.')

SELECT @value = [description] FROM @temp_abundantcode
PRINT @value
Inserting a line break in the NVARCHAR data in SQL Server
%d bloggers like this: