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 ;
Category: sql sever syntax
select SPECIFIC_NAME from msdb.information_schema.routines where routine_type = ‘PROCEDURE’ order by SPECIFIC_NAME
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 )