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, 1812🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...