Are you new to SQL? Do you need some answers without having to read a 200 page book? Then you came to the right place, this eBook covers the top 33 questions any beginning SQL developer wants to know. Stop searching through blogs and random web sites that are just full of ads and get your own copy today!

The basics of T-SQL (Microsoft)

-- How to update a table
-- How to declare variables
-- How to update variables
-- How to get first of month or last day of month
-- How to get Monday/Sunday of previous week
-- How to get monday of current week
-- How to create a temp table
-- How to insert into a table
-- How to insert into a table from another table
-- How to join two tables
-- How to select n number of rows
-- How to select rows in ascending order
-- How to select rows in descending order
-- How to select unique vales (no dups)
-- How to write IF statements
-- How to write Loops
-- How to write a case statement within an update
-- How to check for NULL values
-- How to write an update statement with a sub query
-- How to use the Keyword "IN"
-- How to count all of the rows in a table
-- How to delete contents of a table
-- How to select the smallest/largest value in a column
-- How to pause for n number of seconds
-- How to string match
-- How to dynamically select a column using a CASE statement
-- How to unhighlight key words
-- How to permanently delete a table
-- How to do perform a boolean check
-- How to use the length function
-- How to check if column is numeric
-- How to find tables in database
-- How to find columns in database

Tags: sql, structured query language, tsql, sql crash course, tsql programming, sql introduction, sql recipes