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 drawnai on 04/24/06 21:18

David Portas wrote:
> 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.

Neither does it if it's written down.

>
> --
> 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

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