Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ValuableTime
Starting Member
3 Posts |
 Posted - 2010-09-24 : 09:50:52
|
| Hi,Is there any way we can customize the column name in sql server 2005. I cannot use dynamic sql since the query is very big and does'nt suit for dynamic sql.Actual Column Name is "Order"Needed Column Name is ("Order" + "DateOfOrder")I am querying the "DateOfOrder" in my query. Is this possible?Thanks. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-09-24 : 12:19:16
|
| [code]select [Order] as MyColumnNamefrom MyTable[/code]CODO ERGO SUM |
 |
|
|
|
|
|
Customized Column Names / Alias Name