also can do for INSERT CREATE TRIGGER trig_vacReq ON dbo._vac FOR DELETE AS BEGIN INSERT INTO dbo._vacLog (vacRequestID, firstname, lastname, startdate, enddate, date_entered, LogDate, logevent) SELECT vacRequestID, firstname, lastname, startdate, enddate, date_entered, GETDATE() as LogDate, ‘Deleted’ as LogEvent FROM Deleted END
Author: Josephine
update query like this: WHERE a.lastname COLLATE Latin1_General_CI_AS = k.lastname
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 )