title: Why can't TOP be used with SQLDependency?
body: <p>I have an application using SQLDependency. I want to display the most recent row inserted into a database table to the user when a new row is inserted.</p>
  
  <p>This works as expected when my query is a simple select statement, but given that I want to display the most recently inserted row, I wrote my query as a <code>SELECT TOP</code> statement. This caused multiple exceptions. Upon review of <a href="https://stackoverflow.com/a/7588660/1324019">this</a> question I learned that <code>TOP</code> is not valid with SQLDependency so I will have to find some other solution. </p>
  
  <p>This made me wonder two things:</p>
  
  <p>A) What is the reason for SQLDependency not supporting the <code>TOP</code> expression?</p>
  
  <p>B) The solution I came up with is ordering the results based on id and just displaying the last one. This works fine, but my table has very few rows currently. I'm using a dataset, so I anticipate it slowing down once more rows are inserted - which was why I wanted to limit the query to only the most recent row. Is there a better way to do this?</p>