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
Databases
Syntax
Description
Microsoft SQL Server
SELECT  @local_variable = 
expression                      { 
,@local_variable = expression }  
SET  @local_variable = 
expression  
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.
Oracle
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.