T-SQL Analyzer

# SQL Server Rule: SML028 | | | |----|----| | Assembly | TSQLSmellSCA | | Namespace | TSQLSmellSCA | | Class | TSQLSmellSCA28 | ## Rule Information | | | |----|----| | Id | SML028 | | Friendly Name | Ordering in a view does not guarantee result set ordering | | Category | CodeSmells | | Ignorable | false | | Applicable Types | Model | ## Description Ordering in a view does not guarantee result set ordering ### Examples ```sql Create view dbo.ViewWithOrder as Select top(100000) [TestTableSSDT].Col1 from [dbo].[TestTableSSDT] order by [TestTableSSDT].Col1 -- SML028 ``` _{^{Generated by a tool}}