Collections:
Unicode String Literals in SQL Server Transact-SQL
What are Unicode string literals supported in SQL Server Transact-SQL?
✍: FYIcenter.com
Unicode string literals in Transact-SQL are sequences of characters enclosed in single quotes and prefixed with (N) as N'...'.
String literals are used to provide values to string variables or table columns like NCHAR(40), NVARCHAR(40), etc.
Unicode string literals are also used in string operations in expressions and string arguments in functions.
Here are some simple rules on how to write string literals:
Here are some example on how to write string literals:
PRINT N'FYIcenter.com'; PRINT N'Murphy''s law'; DECLARE @var NCHAR(2); SET @var = N'友爱'; PRINT @var;
⇒ Unicode Character String Literals in SQL Server Transact-SQL
⇐ CHAR(n) - Truncating/Padding Strings in SQL Server Transact-SQL
2017-05-05, 1677🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...