In SSMS, for example
I have a sql query,
now i added alias Sales.SalesPerson sp, want to apply alias name to all the columns quickly, press ALT+Shift button and hold them down while i move my cursor to the lower right of the block.
Now i change to SalesPerson alias name to all column name
I have a sql query,
now i added alias Sales.SalesPerson sp, want to apply alias name to all the columns quickly, press ALT+Shift button and hold them down while i move my cursor to the lower right of the block.
Now i change to SalesPerson alias name to all column name
select
SalesPerson.BusinessEntityID,
SalesPerson.Bonus,
SalesPerson.SalesYTD,
SalesPerson.SalesLastYear
from
Sales.SalesPerson
SalesPerson.BusinessEntityID,
SalesPerson.Bonus,
SalesPerson.SalesYTD,
SalesPerson.SalesLastYear
from
Sales.SalesPerson
No comments:
Post a Comment