How to name query output columns in ms sql server?



How to name query output columns in ms sql server?..

Answer / Chandan Kumar Jaiswal

To name query output columns in MS SQL Server, you can use the `AS` keyword after each column name. Here's an example: `SELECT Column1 AS NewColumnName, Column2 FROM YourTable`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain linked server in sql?

1 Answers  


What is an identity column in insert statements?

1 Answers  


how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  


One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  


can any body tell me how to know the password of current user in sql server

1 Answers   Crea, HCL,


Explain user defined views?

1 Answers  


In which files does sql server actually store data?

1 Answers  


Describe in brief databases and sql server databases architecture.

1 Answers  


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1 Answers  


what is difference between view and Dip.

1 Answers   IBM, L&T,


How can delete duplicate records in cte in sql server?

1 Answers  


How to find out what is the default collation in a database?

1 Answers  


Categories