update query like this: WHERE a.lastname COLLATE Latin1_General_CI_AS = k.lastname
Month: February 2011
Select cells Select the menu choice Data Select the menu choice Text to Columns
SELECT tID , [Country] , [Day] , [Month] FROM ( SELECT t2.tID , t1.ColName , t2.Txt FROM Table1 AS t1 JOIN Table2 AS t2 ON t1.ColId = t2.ColID ) p PIVOT ( MAX([Txt]) FOR ColName IN ( [Country], [Day], [Month] ) ) AS pvt ORDER BY tID ;
select SPECIFIC_NAME from msdb.information_schema.routines where routine_type = ‘PROCEDURE’ order by SPECIFIC_NAME
•In the Start Menu go to Run type “gpedit.msc” and press Enter •Now a Group Policy editor will open. In this window navigate to: Computer Configuration -> Administrative Template -> Windows Components -> Windows Update •Double click on No auto-restart for scheduled Automatic Updates installations…
SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )
alter table table_name add requestdatetime int, myDate datetime DEFAULT(getdate())