Jan
09
Posted under
SQL Server 2005,
T-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 »
Jan
09
Posted under
SQL Server 2005,
T-SQL 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 »
Jan
09
Posted under
SQL Server 2005,
T-SQL 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 »
