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, 1509🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...