Month: February 2011
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 )