Skills SQL Server TSQL: Difference between revisions
| Line 37: | Line 37: | ||
== Joins == | == Joins == | ||
Inner Join | |||
Left Join | |||
Cartesian joins (cross-products) with no where clause | |||
== Stored Procedures == | == Stored Procedures == | ||
Revision as of 11:53, 7 October 2024
Used at:...
Standard SQL
Select, Insert, Update, Delete, Truncate, Merge
Window functions
OVER (ORDER BY col1)
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
Inner Join
Left Join
Cartesian joins (cross-products) with no where clause
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