How to set alias name for column while retrival in sqlserver 2005

Alias name is name which is given by user....

Select Emp_ID, Emp_name from Emp
o/p:
Emp_ID Emp_name
---------------------
101       suresh
102       kumar

If i need to display Emp_ID as Employee Number and Emp_name as EmployeeName, Then we will change our querry as follows

Select Emp_ID AS  Employee Number , Emp_name AS EmployeeName from Emp
o/p:
 Employee Number   EmployeeName

---------------------------------------
101                                   suresh
102                                   kumar