Collections:
Single-byte String Literals in SQL Server Transact-SQL
What are single-byte string literals supported in SQL Server Transact-SQL?
✍: FYIcenter.com
Single-byte string literals in Transact-SQL are sequences of characters enclosed in single quotes.
String literals are used to provide values to string variables or table columns like CHAR(40), VARCHAR(40), etc.
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 'FYIcenter.com'; PRINT 'Murphy''s law'; PRINT '2017-11-31'; PRINT 'Hello '+'Joe!'; DECLARE @var CHAR(16); SET @var = 'Hello World!'; PRINT @var;
⇒ Collation - Character Code Page in SQL Server Transact-SQL
⇐ Types of Data Literals in SQL Server Transact-SQL
2017-05-20, 1657🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...