Prev: search for a string or part of a string in another string
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
First  |  Prev  | 
Pages: 1 2
Prev: search for a string or part of a string in another string
Next: set ARITHABORT on