Collections:
Constant or Data Literal in SQL Server Transact-SQL
What Is a Constant or Literal in SQL Server Transact-SQL?
✍: FYIcenter.com
A constant, or data literal, is a symbolic expression that represents a specific value of a specific data type in SQL Server Transact-SQL. Constants or literals are used commonly as the default values for table columns, variables, and parameters.
Constants or data literals are also used as operands to construct operations and expressions.
Here are some examples of data literals SQL Server Transact-SQL:
-2255 -- A literal represents a negative integer of -2255 1894.1204 -- A literal represents a decimal number of 1894.1204 9.22337e+3 -- A literal represents a floating number of 9223.37 'FYIcenter.com' -- A literal represents a single-byte string N'FYIcenter.com' -- A literal represents a Unicode string 0x69048AEFDD010E -- A literal represents a binary string €542023.14 -- A literal represents a currency value
⇒ Types of Data Literals in SQL Server Transact-SQL
⇐ Data Literals in SQL Server Transact-SQL
2017-05-20, 2314🔥, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...