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, 1523🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...