Skills SQL Server TSQL: Difference between revisions
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
''[[Role_MUFG_Securities|MUFG Securities]]'' | ''[[Role_MUFG_Securities|MUFG Securities]]'' | ||
''[[Role_SSE_Energy_GDPR|SSE_Energy_GDPR]]'' | ''[[Role_SSE_Energy_GDPR|SSE_Energy_GDPR]]'' | ||
''[[Role_ING_Investment_Management|ING Investment Management]]'' | |||
</div> | </div> | ||
</div> | </div> | ||
Revision as of 09:45, 7 October 2024
Used at:...
Window functions
Group by/aggregation
WHERE clause / Having
CTE - Common Table Expressions
Used at:...
Used at: MUFG Securities
Use of SQL Server CTEs (Common Table Expressions).
Sorting
Sort by
Sub-queries
Views
Joins
Stored Procedures
Used at:...
Used at: MUFG Securities Five Guys Premier Foods Autodata
Pivot
Used at:...
Used at: Autodata
Pivot function
Unpivot function
Union
Used at:...
Used at: Autodata
Union
Union All
Datatypes
Int, VarChar(8000), DateTime
Dynamic SQL
Used at:...
Used at: Autodata
Dynamic SQL
SQL Injection
Other
Cursors
BCP - Bulk copy protocol
Triggers