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;
2017-05-20, 930👍, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Count Duplicated Values in a Column in SQL Server? If you have a column with duplicated value...