select value into variable and alias in SQL Server

Question

I'd like to simultaneously do two things in an MSSQL query:

select a field's value into a variable select @myvar = colName from tableName
alias my column select colName as [myCol] from tableName

I've tried these things:

Attempted Syntax select @myvar = colName as [myCol] from tableName
Attempted Syntax select @myvar = (colName as [myCol]) from tableName
Attempted Syntax select (@myvar = colName) as [myCol] from tableName
checked select statement syntax: https://msdn.microsoft.com/en-us/library/ms176104.aspx

If this is possible, how can it be accomplished?

What impact would the alias have after the select? It would not be associated with @myvar and a select-assign returns no rows, do you want to assign and select as a row? - if so just select @myvar as [myCol] — Alex K.
– Alex K., Commented Feb 24, 2016 at 14:38
@Faisal I don't strictly need the alias, but I desire it for maintenance reasons. — colbybhearn
– colbybhearn, Commented Feb 24, 2016 at 15:13
@AlexK. Impact: None on execution of the query. I don't want to select the variable value as a row, no. Thanks! — colbybhearn
– colbybhearn, Commented Feb 24, 2016 at 15:16
select @myvar = (select (select colName as [myCol] from tableName)) is probably the closes you will get if you want to do come kinf of textual analysis on the source — Alex K.
– Alex K., Commented Feb 24, 2016 at 15:29

HABO · Accepted Answer · 2016-02-24 16:07:08Z

3

A select can either assign values to variables or return column values, but not both.

In some cases, e.g. when using select to provide data to an insert, an output clause may be useful. A tool well worth having in your pocket as it provides access to identity values from insert and both before and after values when used with update.

answered Feb 24, 2016 at 16:07

HABO

15.9k5 gold badges44 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

select value into variable and alias in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related