Prev: running total column help
Next: set ARITHABORT on
From: Erland Sommarskog on 19 Apr 2010 09:10 fniles (fniles(a)pfmail.com) writes: > Aha, you got it. > I added column Symbol to the index, and column Symbol is a computed column > with the following specification: (rtrim([CommodityCode]) + [MonthYear]) > > So, if the database is in SQL 2005, I will not need to "SET ARITHABORT ON" > ? Correct. (There still some situations in SQL 2005 where you need to have ARITHABORT ON, to wit when you work with the xml data type. But for indexed views and indexed computed columns ARITHABORT does not matter.) -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx |