Table of ContentsPreviousNext

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer SQL Server to Oracle Migration overview.

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
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.