You could delete a row in SQL 2008 using the DELETE statement, which removes one or more rows in a table or view.
The following example deletes all rows from the CarPriceHistory table in which the value in the RegularPrice column is more than 20000.00.
USE AllCars;GODELETE FROM Cars.CarPriceHistoryWHERE RegularPrice > 20000.00;GO
Your hosting company should support SQL 2008 hosting to host ASP.NET …