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, 1634🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...