Select random rows from a MS-SQL Server table

SELECT TOP 1 *
FROM TABLE_NAME
ORDER BY NEWID()

Select Only Year of Datetime MSSQL

SELECT DISTINCT CONVERT(CHAR(4), @DatetimeValue, 120) as Year

FROM Events

Select Only Month of Datetime MSSQL

SELECT DISTINCT CONVERT(CHAR(3),@DatetimeValue, 100) as MONTH

FROM Events

this server version is not supported. you must have microsoft sql server 2005 beta 2 or later

Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support

Brief Description

This update enables developers to use Microsoft Visual Studio 2005 Service Pack 1 with Microsoft SQL Server 2008.

Download & Install it:

http://www.microsoft.com/downloads/details.aspx?FamilyID=E1109AEF-1AA2-408D-AA0F-9DF094F993BF&displaylang=en

MSSQL CREATE UNIQUE NONCLUSTERED INDEX

CREATE UNIQUE NONCLUSTERED INDEX [IX_INDEXNAME] ON TABLENAME

(

COLUMNNAME ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO