What is the SQL Server 2005 SQL syntax for dropping a column?

The following is the general syntax for deleting a column from a table:
ALTER TABLE table_name
DROP COLUMN column-name

How do I connect my ASP.NET project to the AdventureWorksLT database?

Establishing database connections to SQL Server 2005 is pretty straight forward, provided that you have the necessary components:

• SQL Server 2005 Express
• Visual Web Developer 2008 Express
• Microsoft SQL Server Management Studio Express

Read the rest of this entry »

How do I concatenate characters or strings using SQL?

Concatenation (joining 2 or more characters or strings of the same data type) is accomplished using the “+” operator. For example, let’s say that I want to join the strings “Able” and “Baker”. To do so, I would simply write:

SELECT 'Windows' + 'Vista' AS OSName

Running this query would return:
Read the rest of this entry »

How do I select only the date from a datetime data type?

Selecting only the date portion from a datetime data type could be accomplished in a number of ways. One of the most convenient methods is to simply use CONVERT and one of the many style values.

SELECT GETDATE() AS MyDate

returns the default format:
Read the rest of this entry »

How do I select the name for a day of the week?

Selecting the name for a day of the week is fairly straight forward using the DATENAME function and a DATEPART argument. For example:

SELECT DATENAME(weekday, GETDATE()) AS 'MyDay';

returns:
Read the rest of this entry »