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

 
 
 MS Dynamics CRM Contributor
MS Dynamics CRM Contributor 
 
 
 
No comments:
Post a Comment