Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software

Assignment Statements

Assignment statements are used to assign values to variables. Different databases support various variants of assignment statements.

TABLE 29. Various variants of assign statements
Microsoft SQL Server
SELECT  @local_variable = 
expression                      { 
,@local_variable = expression }  
SET  @local_variable = 
Sets the specified local variable, previously created with the DECLARE @local_variable statement, to the given value.
Expression is any valid expression including a scalar subquery.
local_variable := expression 
Assignment operator assigns a value to a variable.
Expression is any valid expression. You cannot specify a subquery in the assignment operator.

Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.