Beware of computed columns
If you use computed columns a lot, you might want to know about some new behavior in SQL Server 2005.
Kevin Kline, SolarWinds
October 9, 2007
1 Min Read
If you use computed columns a lot, you might want to know about some new behavior in SQL Server 2005.One of the changes in SQL Server 2005 was to evaluate expressions in queries to match computed column expressions and identify redundant expressions, in order to prevent run-time errors in queries that have unsafe expressions. This is documented in the behavior changes topic: http://msdn2.microsoft.com/en-us/library/ms143359.aspxCheck it out,-Ke
About the Author
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
You May Also Like