TOP 100 PERSENT in view

  • Thread starter Thread starter Kikoz
  • Start date Start date
K

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
 
Actually it was a bug in SQL Server 7 when views worked slower using this
clause

--
Val Mazur
Microsoft MVP


Miha Markic said:
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

Kikoz said:
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
Click to expand...
Click to expand...
 
Back
Top