SQL

• @@ROWCOUNT
• CASE
• CROSS APPLY
• CURSOR
• DROP TABLE IF EXISTS
• INTERSECT & EXCEPT
• LAG & LEAD
• MERGE
• NOT EXISTS
• OFFSET FETCH
• OUTPUT
• PIVOT
• RANK
• STORED PROCEDURE
• TRY-CATCH
• WINDOW FUNCTION