Topics
- Getting started with Java Language
- Getting started with SQL
- Getting started with Microsoft SQL Server
- JOIN
- UPDATE
- ORDER BY
- Filter results using WHERE and HAVING
- Retrieve information about the database
- Common Table Expressions
- LIKE operator
- Cursors
- Join
- DELETE
- String Functions
- Data Types
- Dates
- Comments
- Subqueries
- Execution blocks
- Row number
- Variables
- NULL
- String Functions
- DBMAIL
- Transaction isolation levels
Examples
- Basic explicit inner join
- Updating All Rows
- Use ORDER BY with TOP to return the top x rows based on a column's value
- Use IN to return rows with a value contained in a list
- Use LIKE to find matching strings and substrings
- SELECT all rows and columns from a table
- Count the Number of Tables in a Database
- Temporary query
- generating values
- Match open-ended pattern
- Inner Join
- Cross Join
- Single character match
- Match by range or set
- DELETE certain rows with WHERE
- DELETE all rows
- Trim empty spaces
- Concatenate
- Upper & lower case
- Substring
- Split
- Stuff
- Length
- DECIMAL and NUMERIC
- FLOAT and REAL
- Integers
- MONEY and SMALLMONEY
- BINARY and VARBINARY
- CHAR and VARCHAR
- NCHAR and NVARCHAR
- UNIQUEIDENTIFIER
- Date & Time Formatting using CONVERT
- Single-line comments
- Multi-line comments
- Using BEGIN ... END
- Row numbers without partitions
- Row numbers with partitions
- Date & Time Formatting using FORMAT
- Declare multiple variables at once, with initial values
- Filtering for NULL in queries
- Nullable columns in tables
- Updating fields to NULL
- Inserting rows with NULL fields
- Char
- Len
- Concat
- LTrim
- RTrim
- Comments in code
- Get the current DateTime
- Space
- DATEADD for adding and subtracting time periods
- Date parts reference
- DATEDIFF for calculating time period differences
- DATEPART & DATENAME
- Getting the last day of a month
- Compound assignment operators
- Rudimentary cursor syntax
- Overview
- String_Split
- Get all schemas, tables, columns and indexes
- Send simple email
- Send results of a query
- Send HTML email
- Format
- Read Uncommitted
- Read Committed
- What are "dirty reads"?
- Repeatable Read
- Snapshot
- Serializable
