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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Creating a column

Author  Topic 

sqldba2k6
Posting Yak Master

176 Posts

Posted - 2007-02-27 : 10:35:23
I have select query

Select customer from customer.

I want to a column which is not in a table.
it should display null when select query is executed.

Please help.


sqldba2k6
Posting Yak Master

176 Posts

Posted - 2007-02-27 : 10:41:07
I got the results thanks
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-27 : 10:41:49
[code]
select customer, null as [somecolwhichisnotinatable]
from customer
[/code]


KH

Go to Top of Page
   

- Advertisement -