Assigning Result to a column within a query using sql server

Two ways of assigning the result to a column name using sql Server:


SELECT id,

DATEDIFF(dd, ShipDate, GETDATE() ) AS colDate
FROM table1


SELECT id,

       colDate= DATEDIFF(dd, ShipDate, GETDATE() )
FROM table1

The Techi Talkers