•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())
SELECT FullName FROM ( SELECT FullName = LastName + ‘, ‘ + FirstName FROM Employees ) sub WHERE sub.FullName = ‘Bertrand, Aaron’
SELECT is_broker_enabled FROM sys.databases WHERE name = ‘msdb’; EXECUTE msdb.dbo.sysmail_help_status_sp; –if stopped then run EXECUTE msdb.dbo.sysmail_start_sp;
CAST( FLOOR( CAST( GETDATE() AS FLOAT ) ) AS DATETIME )