Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Computed Columns

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2000-08-10 : 07:01:37
John writes "Hi, Is it possible to generate psuedo columns in a stored procedure and if so how? I.e. returns a result set with a column which doesn't exists on any of the tables involved in the query. I've looked into using a local variable but to no avail. Thanks." In this article we'll discuss creating computed columns based on other columns.

Article Link.

Yak Posting Veteran

70 Posts

Posted - 2005-11-22 : 11:14:19
Is it not possible to add a full text index to a computed column? It doesn't seem to allow this (says the table does not have a column called <blah>).

I'm trying to use CONTAINS to search multiple columns without resorting to dynamic SQL which will make recordset paging really difficult. Computed columns seemed like a good solution (to create a composite column) until I realised you can't index them.
Go to Top of Page

- Advertisement -