How to delete a row in sql 2008

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;
GO
DELETE FROM Cars.CarPriceHistory
WHERE RegularPrice > 20000.00;
GO

Your hosting company should support SQL 2008 hosting to host ASP.NET with MS SQL 2008.