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;
2017-05-05, 930👍, 0💬
Popular Posts:
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...