Upsizing an Index

[Mike555]

I'm in the process of converting several Visual FoxPro 6.0 databases to SQL Server. Table indexes in VFP can be expressions. For example - I have a VFP table with an index expression as follows...

Location+DTOS(StartDate)

But you can't create indexed expressions such as this in SQL Server can you? How do I go about creating this index in SQL Server?

Thanks for your help.

 

[mrdenny]

You can create columns that hold formulas of data in other columns. Is that what you are trying to do?

As an example
C1, C2, E1
A, 12, A12
D, 7, D7
...

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[Mike555]

It seems like that is the only possibility. I know that calculated rows reduce efficiency in SQL Server, and was hoping there was another way around this.

 

[mrdenny]

That's going be to the method. They aren't fast (and the break the sql maintaince plans) but it'll get the job done.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief