You are here: Re: stored procedure to concatenate column value sin a single cell? « MsSQL Server « IT news, forums, messages
Re: stored procedure to concatenate column value sin a single cell?

Posted by Erland Sommarskog on 01/09/07 09:08

Plamen Ratchev (Plamen@SQLStudio.com) writes:
> I believe you are referring to the behavior explained in this KB article:
> http://support.microsoft.com/default.aspx/kb/287515
>
> The way this query is written it follows exactly the workaround solution
> explained in the article (to apply any function or expression to the
> SELECT list columns rather than in the ORDER BY clause). According to
> the article then the query will achieve the expected results.

But observe the first paragraph under CAUSE. The article then bends over
backwards to do it anyway, which contradicts the first paragraph. I prefer
to trust that first paragraph that says the correct behvaiour is undefined.

> This query was tested with both SQL Server 2000 and SQL Server 2005.

Yes, but did you get expected results, because you should get them, or
was it mere chance? Compare the TOP 100 PERCENT .. ORDER BY in views that
many incorrectly relied on in SQL 2000, and then were bitten by in
SQL 2005.



--
Erland Sommarskog, SQL Server MVP, esquel@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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация