How I create new column in sql server?

[Chandrakanta Sen]

I have two table such as table1 and table2 using sql joining query i have fetched or shown some desired result but for good looking i want to create some extra user defined columns, which i can't create... Please help as early as possible...

[Andrius Leonavicius]

Hi, I'm not sure what are you trying to do... Maybe you could give some example?

[Mycroft Holmes]

In your query you include the calculation and give the result a name, it is then treated as a column in your result set.

Select Town, Region + ' ' + State as Place
from TableName

This will create a column called Place in your result set.

Never underestimate the power of human stupidity RAH

[User 10361121]

First Create a new table with using select command and then you can fatch data from those tables. And after that you can add any column in new table.