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, 2364🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...