Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Select
Miscellaneous
Thread ID:
00854697
Message ID:
00854697
Views:
68
Hi All:
How can I save the value of a field in a variable in my select
statement.

For example:
SELECT Bill_Master.Amt as Loc_Price,
Loc_Price + 1 as As tds

I want to save the value of amt in a variable call Loc_Price and select
Loc_Price + 1 as tds

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform