How to remove TOP (100) PERCENT with MS SQL Server management studio 2008?
Posted on 2012-09-15
When I make new query on Microsoft SQL Server Management studio 2008 in query designer I always get SELECT TOP (100) PERCENT dbo.LPrgPlans.LPrgPlanI
How to remove this TOP (100) PERCENT ??? Now I always remove it manually because I post the code in C# project and ... but it is stupid to remove it manually…
And at all – which tool you use to make your DB - SQL tables, views, Sp ? At all ... this Management Studio is NOT designed to handle with 200+tables, 600 SP , look to me that is written from Microsoft’s “developers by paper” who never face with the real problems that developers works … Any feature for navigation is missing… a feature to group somewhere tables, views, sp IN ONE LIST is missing , the result is that 10-20 % of the developers time is lost for navigation …