title: Set a limit on the number of rows of a SQL Server table
body: <p>I would like to set a maximum number of rows a SQL Server table I created can have. The thing is that I have a program that constantly writes new data in my datatable, but I only need to storage one value per column. So I'd like to set my maximum amount of possible rows for this datatable to one. Does anyone have an idea how to do this?</p>
  
  <p>Otherwise as I haven't found a possibility to do this so far, I also thought about rewriting my code and using the SQL <em>UPDATE</em> statement.</p>
  
  <p>I am not so sure about what would be better.</p>