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.aspx
Check it out,
-Kev
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About KKline
Kevin Kline is Technical Strategy Manager for the SQL Server business unit at Quest Software. Kevin was the original architect and dev manager for many of Quest's SQL Server tools. Prior to Quest, Kevin worked as an enterprise DBA for a variety of large corporations and government agencies.