TOP 100 PERSENT in view

[Kikoz]

Hi all.

When I create a view using VS.NET 2003 it sometimes inserts TOP 100 PERSENT
right after SELECT clause. Why? It will slow down execution, right?


Thanx for any help

 

[Miha Markic [MVP C#]]

Hi Kikoz,

I don't think it will degrade the performance.

 

[Val Mazur]

Actually it was a bug in SQL Server 7 when views worked slower using this
clause

--
Val Mazur
Microsoft MVP

Hi Kikoz,

I don't think it will degrade the performance.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

Hi all.

When I create a view using VS.NET 2003 it sometimes inserts TOP 100 PERSENT
right after SELECT clause. Why? It will slow down execution, right?


Thanx for any help