Collections:
SET Statements in SQL Server Transact-SQL
How to assign value to a variable in SQL Server Transact-SQL? How to use the SET statements?
✍: FYIcenter.com
In Transact-SQL, you can use SET statements to assign values to variables
using the assignment operator =, in the syntax of:
SET @variable = <value>
When an SET statement is executed, the system will:
Here are some example on how to assign values to variables:
-- Data type matches, no implicit conversion DECLARE @price MONEY; SET @price = 9.99; PRINT @price; ---- 9.99 -- Data type does not match, implicit conversion applied DECLARE @now DATETIME; SET @now = 'Jan 1, 2000' PRINT @now; ------------------- Jan 1 2000 12:00AM -- Implicit conversion fails DECLARE @bonus MONEY; SET @bonus = 'FIFTY DOLLARS'; PRINT @bonus; ----------------------------------- Msg 235, Level 16, State 0, Line 13 Cannot convert a char value to money. The char value has incorrect syntax.
⇒ PRINT Statements in SQL Server Transact-SQL
⇐ DECLARE Statements in SQL Server Transact-SQL
2017-04-04, 1601🔥, 0💬
Popular Posts:
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...