You are here: Re: Order by in a INSERT INTO..SELECT « MsSQL Server « IT news, forums, messages
Re: Order by in a INSERT INTO..SELECT

Posted by David Portas on 04/24/06 15:40

drawnai@hotmail.com wrote:
>
> Are you saying my query doesn't work? No? I didn't think so.

I'm saying you can't demonstrate that it does.

> > Since you can't predict whether those situations will arise at runtime
> > you have to take a calculated risk before you implement those
>
> Not true. I actually run them to find out.

Which proves nothing because execution plans can change at runtime.

> I'm well aware of the risks, which is why I have a list of
> features I
> use that are periodically checked. This includes documented features.

Proves nothing. See above.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

 

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

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