SQL Server Tutorials

Create a SQL Server login that uses Windows Authentication

1.In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.

2.Right-click the Security folder, select New, and then click Login.

3.Enter the name of a Windows user in the Login name box.

4.Select Windows Authentication.

5.Click OK.

Create a SQL Server login …

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 …